ComboBox Shows Choices But They Are Empty

Like (0) Share

Report

Posted on 13 Jun 2022 15:41:21 by KEarley

276

My Combobox shows a list of options to choose from, but all are blank.

I have tried multiple ways to fix it, but none crate the expected behavior.

Here are some screenshots:

This is what PowerApps has for the data:

This is the ~~table~~ List definition :

Strange enough. This is code generated by PowerApps when I added the form:

This is what I replaced it with:

These are some of the results I got when trying different things:

This is the properties at one point:

Categories:

General Questions

All responses (10)

Answers (0)

KEarley 276 on 13 Jun 2022 at 19:00:25

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Any more ideas?
KEarley 276 on 13 Jun 2022 at 16:26:20

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Several times, in the past day. I've changed it to a Choice column too. Each time I remove the data card and re-add it. Regardless of what I do, I get the same result. There is one other result I have gotten and that is "Value". In the properties, when you do a data edit to change from single to double, I have gotten a single choice in there and it was "Value". That's the only choice. I get the same results though.
KEarley 276 on 13 Jun 2022 at 16:24:30

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Right. Not sure why either, but PowerApps tends to do that in formulas it generates. I've tried changing it to TableName.ColumnName and ThisItem.Co;umnName, and setting it to just the datasource name. I pretty much get the same issue.
Gerard Simpson 2,987 Moderator on 13 Jun 2022 at 16:23:32

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Thanks @KEarley - have you by any chance change this field type in Sharepoint in last hour or so?

You might just need to remove the datacard from the form, do a refresh of your data and then re-add the field to your form.
Gerard Simpson 2,987 Moderator on 13 Jun 2022 at 16:19:06

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

@KEarley - I'm not quite sure why your SharePoint list is showing a single line text field for the ReportName column, but your items property in the app shows a record datatype under a column named 'field_1'?
KEarley 276 on 13 Jun 2022 at 16:15:56

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Additional, in case it helps: I deleted the entire form, re-added it, and connected it to the data source. Powerapps generated the controls and code behind the controls, as usual. Interesting that it used the following, and the formula it used was invalid...
KEarley 276 on 13 Jun 2022 at 16:06:32

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Yes. Is this what you mean?
Gerard Simpson 2,987 Moderator on 13 Jun 2022 at 16:00:43

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

Can you highlight your dropdown 'Items' property in the formula bar and expand the preview of your items table that appears below the formula bar after you have highlighted it - and send a sceenshot?
KEarley 276 on 13 Jun 2022 at 15:53:53

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

I did. It has the same result.
If it helps...here is the list settings:
Gerard Simpson 2,987 Moderator on 13 Jun 2022 at 15:52:29

Like (0)

Report

Re: ComboBox Shows Choices But They Are Empty

@KEarley - try changing the layout to single as it is only a single column you are displaying. This might resolve the issue. Also make sure, the display and search both show ["Value"]