Unanswered

PowerApps In Teams Combo Box Distinct Function Not Working

(1) Share

Report

Posted on by jms0529

I am using Power Apps in Teams which does not offer dropdowns. Instead, I have Combo Box options. I have been struggling to get the combo box working. I am finally displaying the options in the desired column. However, when I use the Distinct function it is still displaying same items multiple times in the combo box.

I am using the following in the Items field.

Distinct('Data Source',ColumnName)

Any suggestions / help greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jms0529 ,

All seems fine based on the formula you provided. Have you made sure you selected the ["Value"] column in the DisplayFields property?

Was this reply helpful? Yes No
jms0529 36 on at

Like (1)

Report

@BCBuizer Teams version of Power Apps does not appear to have a DisplayFields Property.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jms0529 ,

Indeed the Fluent UI ComboBox (https://learn.microsoft.com/en-us/power-apps/teams/use-the-fluent-ui-controls#combo-box) in Teams is different from the classic ComboBox (https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-combo-box).

Perhaps there's this possibility in the Porperties Pane:

Primary text should be Value.

Was this reply helpful? Yes No
jms0529 36 on at

Like (1)

Report

There is no Primary text element in the Teams version.

I should also update this slightly.

If I use the distinct function in the Items element I get blank options. IE: the correct number of options field display but they are blank.

If I only reference the datasource in the Items element and use the distinct function in the DefaultSelectedItems element then it displays each option multiple times.

Either way I have not successfully gotten a distinct list of options to display.

Was this reply helpful? Yes No
jms0529 36 on at

Like (2)

Report

@BCBuizer

I finally figured it out with a ton of web surfing.

I only needed code in the Items element. Under Properties I had to select the fields edit button and add the field Values and move the values field to the top of the list. After doing that the following code works.

Distinct('Data Source',ColumnName)

Was this reply helpful? Yes No
CU23011914-0 63 on at

Like (0)

Report

Jeez that's fun to troubleshoot.

Thanks a ton.

Was this reply helpful? Yes No
PHemingway610 129 on at

Like (0)

Report

THANK YOU. Been stuck on this all afternoon and evening. Finally got the answer here and now it works! Crazy that it has to be this way.

Was this reply helpful? Yes No