Answered

PowerApps In Teams Combo Box Distinct Function Not Working

Like (1) Share

Report

Posted on 27 Jul 2023 19:37:19 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:

Using Apps Using Formulas

All responses (7)

Answers (1)

PHemingway610 123 on 22 Mar 2025 at 05:23:58

Like (0)

Report

PowerApps In Teams Combo Box Distinct Function Not Working

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.
CU23011914-0 63 on 23 Jan 2025 at 19:14:52

Like (0)

Report

PowerApps In Teams Combo Box Distinct Function Not Working

Jeez that's fun to troubleshoot.

Thanks a ton.
jms0529 36 on 31 Jul 2023 at 19:20:02

Like (2)

Report

Re: PowerApps In Teams Combo Box Distinct Function Not Working

@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)
jms0529 36 on 31 Jul 2023 at 16:34:03

Like (1)

Report

Re: PowerApps In Teams Combo Box Distinct Function Not Working

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

BCBuizer 22,070 Super User 2025 Season 1 on 27 Jul 2023 at 19:58:58

Like (0)

Report

Re: PowerApps In Teams Combo Box Distinct Function Not Working

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.
jms0529 36 on 27 Jul 2023 at 19:51:43

Like (1)

Report

Re: PowerApps In Teams Combo Box Distinct Function Not Working

@BCBuizer Teams version of Power Apps does not appear to have a DisplayFields Property.
BCBuizer 22,070 Super User 2025 Season 1 on 27 Jul 2023 at 19:45:20

Like (0)

Report

Re: PowerApps In Teams Combo Box Distinct Function Not Working

Hi @jms0529 ,

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