ComboBox Shows Choices But They Are Empty

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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"]

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(0)

Report
Copy link

Link copied!

I did. It has the same result.
If it helps...here is the list settings:

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. Is this what you mean?

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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'?

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(0)

Report
Copy link

Link copied!

Any more ideas?

Was this reply helpful? Yes No