Answered

Sharepoint list works in a dropdown but displays nothing in a combobox.

(1) Share

Report

Posted on by GregCJS

I have a SharePoint list with 2 columns Title and Clock No, I want to use a Combobox for both. When I use it for the title it works fine, but when I try to use a Clock No column I get a list of empty values (Clock No 1). The formula is just there to remove blank cells and still doesn't work if removed as can be seen from the screenshot the data is showing fine (Clock No 2). I have tried that exact formula in a Dropdown and it works fine (Clock No 3).

In the meantime I have resorted to using a Collection but that is not ideal, any help would be greatly appreciated.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @GregCJS ,

Could you please share more details? Which type is the clock no. column? Have you selected display field for the Combo box on the property panel? I see the actual column name is "field_1" from in the second screenshot, so please try below formula for Items of the Combo box:

Filter('EE Responsible', !IsBlank('Clock No'))

then select the field_1 as the primary text on the property panel.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
GregCJS 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi v-jefferni,

Thank you very much for your reply.
I have created a new Screen and a new ComboBox to help narrow the problem.
Could you please explain what you mean by "Have you selected display field for the Combo box on the property panel?" I am sorry but, I don't quite understand what you mean.
I have used the formula that you have recommended and it worked perfectly, however I want to display Clock No not the names (Clock No 4).
I have added a .'Clock No' at the end to display the correct column but, it is still showing nothing (Clock No 5).
Lastly, please see attached for the details of the Column in SharePoint (Clock No 6).

Many Thanks,
Greg
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GregCJS ,

While using a multi-column table as the data source of Combo boxes, you will be able to select a text/number type column from the property pane to determine the display column:

So basically we will not narrow down the table to a single column. From your end, you could select field_1 as the primary text field to display in the dropdown of the Combo box.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
GregCJS 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi v-jefferni,

Thank you for the suggestion I have tried to do that, however neither field_1 or Clock No is on the list, I have went through the list and I could not find the right values:
I have also re-created the SharePoint list but it did not fix it.

Many Thanks,
Greg
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GregCJS ,

It would be better to share the screens of the list and column settings first.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
GregCJS 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni,

Thank you for your reply.
Here are the settings for the Clock No column, I had to redact the title column as it held Sensitive information:
Could you please let me know which settings you require? There are a lot of Hyperlinks here:
I hope that these helped, and I look forward to your next response.

Many Thanks,
Greg
Verified answer

GregCJS 27 on at

Like
a
(0)

Report
Copy link

Link copied!

I have resolved it, it was not a number nor text.
I have just done ForAll(Source,Text(ClockNo)) and that works fine.