Answered

Combo box shows only blank values

(0) Share

Report

Posted on by Baltner

149

Greetings:

I have a data table, 'Change Requests' with a Lookup column called CR_Status that has about nine different status values. Now I want to display all the choices from that column in a combo box that is not inside a form or gallery. How do I do that? I tried

Choices('CR_Status (Change Requests)')

This gives me 9 rows (I think) in the dropdown but they are all blank. I also tried

Distinct('Change Requests', CR_Status)

but I get blank values there too.

I have confirmed that:

CR_Status is a Lookup
each item in the Change Requests table has a CR_Status
There are no filters in the combo box
The Distinct function does NOT work on another column that also has data
Refreshing the data source does not resolve the problem.

Why am I getting blank values? If I use the first option (Choices...) in a Combo Box within an EditForm with 'Change Requests' as the data sourceI get the correct behavior. Can'r you have a Combo Box outside of a form?

Thanks!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Check here
Baltner 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick reply but I'm not seeing what you have in the screen shot. Here's mine:
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Weird, haven't had a combobox with custom values liek that show up before.

Are these items in the combobox going to always be same or always changing?

If you try adding another fresh combobox with items property of

Distinct('Change Requests', CR_Status)

and then check if you can now set the Primary Text of the ocmbobox to Result, does that still give blanks?

What does datatable source of the combo box look like
Verified answer

SolTeferi on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Baltner ,

Select the combobox and then follow what @TheRobRush provided. I think you are selecting a form control.
Baltner 149 on at

Like
a
(0)

Report
Copy link

Link copied!

I was selecting a Combo Box and not a form control. But I did some experiments and found something relevant to this problem:

First, for full disclosure, this app started out as a Power Apps for Teams app because I wanted to use Dataverse without it being a Premium connector. Later I made a (bad) decision to move this to a non-Teams Power App and that worked OK except that the controls available were different. Instead of Text Input I had a Text Box, and Combo Box instead of Dropdown, for example. The Button control also was different. I think these are the so-called Fluent UI controls. But I later discovered that I could also add "Classic" controls.

With that extra information, I discovered that the problem I described above was because of the 'Fluent UI' combo box. When I use the 'Classic' Combo Box I not only see the options that @TheRobRush provided, but also get the behavior that I wanted simply by setting Items to `Choices('Change Requests'.CR_Status).` So my entire problem is probably a result of me moving between these two types of controls.

Sorry that I forgot to mention this before. Due to licensing I may have to convert this back to a Power Apps for Teams app and I'll probably have to revisit problems like this again that are due to different controls being used in different versions of Power Apps. IMHO this is a very bad situation but it may just be that I don't yet know enough about these Fluent UI controls and the advantages that they (supposedly) offer.