Answered

Distinct in Combobox not displaying choices

(1) Share

Report

Posted on by S S

115 Season of Giving Solutions 2025

I am adding Distinct to this combobox. There are no error messages but it doesn't display the choices when I play the app

Distinct(
    Filter(
        ColCommands,
        EchII in 'ComboboxCanvas2-EchII_7'.SelectedItems
    ),
    EchII
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (5)

Verified answer

PowerDeveloperTP 379 on at

Like (0)

Report
Copy link

Link copied!

Hello @S S

Could you please make sure you have set DisplayFields for combo box

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
Verified answer

DP_Prabh 315 on at

Like (0)

Report
Copy link

Link copied!

Hi @S S,

I think you are filtering second combo box based on 1st combo box selected value. the code is correct please check these properties are they mapped correctly or not:

If this mapping is correct, then it should return the correct data in Combo box2.

I hope this works for you!

Was this reply helpful? Yes No
Verified answer

Kalathiya 1,568 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @S S,

That could be multiple reason:

#1.

Looks like a cascading dropdown.

Currently your filter depends on what’s selected in the parent combo box. If not selected anything in parent combobox, the filter returns no data so it will not show anything.

Distinct( Filter( ColCommands, (IsEmpty('ComboboxCanvas2-EchII_7'.SelectedItems) || EchII in 'ComboboxCanvas2-EchII_7'.SelectedItems) ), EchII )

Currently, I have updated the filter condition if nothing is selected in Parent combobox it will show the data. Could you please check and confirm?

#2. Reason - 2
Sometimes, even after setting the Items property, the combo box option still show blank. This usually happens if the field didn’t refresh properly. Just reselect the field in the combo box, and the values should appear.

So, try resetting the DisplayFields property. Remove the values first, apply the change, and then set them again. Doing this once or twice usually refreshes the combo box, and the values should start showing correctly.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Verified answer

11manish 457 on at

Like (0)

Report
Copy link

Link copied!
try below :

Select the ComboBox in the editor.

Go to the Properties pane on the right.

Click Edit next to Fields.

Change the Display name (and Search name) from EchII to Value (or Result)

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,625 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @S S,

In addition to what the previous contributors have (repeatedly) mentioned, it is worrth noting there are multiple versions of comboboxes available in Power Apps. Depending on when the combobox got added, you're dealing with one version or another and unfortunately, each of them has a different way of setting the field(s) to be displayed.

Just some examples:

Classic/ComboBox@2.4.0; go for the solution that was proposed by @PowerDeveloperTP

ComboBox@0.0.51; Click on fields and then add the Value field:

ModernCombobox@1.0.0; Set the ItemDisplayText property:

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
S S 115 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the many responses. I am going to work through each of these tonight and will post my results.

Was this reply helpful? Yes No
S S 115 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!
@BCBuizer You're right there are different versions. I thought every had the same version. This makes working through solutions.

@DPPrabh

I'm not sure how to get the mapping done.

@11Maning-How would I change the name?

PowerDeveloperTP

I must have a different version of Power Apps since I don't see Display fields the same way you do

@Kalathiya Confirming showed the data

Distinct( Filter( ColCommands, (IsEmpty('ComboboxCanvas2-EchII_7'.SelectedItems) || EchII in 'ComboboxCanvas2-EchII_7'.SelectedItems) ), EchII )

Was this reply helpful? Yes No