Modern Combo Box, Item property has "distinct" in it, text is not showing

(0) Share

Report

Posted on by wonka1234

909 Super User 2024 Season 1

Hi,

I have a modern combo box in my app.

The values are "invisible" however I can select the values.

my items property contains a distinct - Distinct([@'Scheduling List_Utilization'],field_1)

according to this - https://powerusers.microsoft.com/t5/Building-Power-Apps/Combo-Box-items-not-visible-text-not-showing/m-p/925364#M293646

distinct values are not liked by combo box. My distinct list contains maybe 1500 values.

Anything can be done here?

All responses (5)

Answers (1)

Verified answer

ANB 7,075 Super User 2025 Season 1 on at

Like (0)

Report

Re: Modern Combo Box, Item property has "distinct" in it, text is not showing

@wonka1234 , This is what it will have just Value:
Once you have it, then value should come .

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Modern Combo Box, Item property has "distinct" in it, text is not showing

@ANB

With the combo box selected I am doing this first -

I see it as a text column -

now i see it under my combo box -

items property -
ANB 7,075 Super User 2025 Season 1 on at

Like (0)

Report
Re: Modern Combo Box, Item property has "distinct" in it, text is not showing

@wonka1234 , Can you confirm on the screenshot that provided? Also what is data type of column? The Items should be this:
Distinct('Scheduling List_Utilization',field_1)

Thanks,
ANB
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Modern Combo Box, Item property has "distinct" in it, text is not showing

@ANB thanks but im unsure on the next steps..

Do I just do - Distinct([@'Scheduling List_Utilization'],field_1).Value
ANB 7,075 Super User 2025 Season 1 on at

Like (1)

Report
Re: Modern Combo Box, Item property has "distinct" in it, text is not showing

HI @wonka1234, Once you write down this code on Items property combo box, then in the field it will be Value not the actual column name as shown below:
Distinct('Scheduling List_Utilization',field_1)
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB