Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
Ask a Question

PowerApps combobox distinct values

0 like 0 dislike
7k views
in Power Apps by ●2 ●2 ●3

I want to fill Compobox in Power Apps with a distinct value from the Sharepoint list, I used the formula syntax Distinct( Table, Formula ), in the Formula I write the field name but it didn't show anything in the Combobox.

Any help how can I fill Combobox with district values in PowerApps?


1 Answer

2 like 0 dislike
by ●48 ●54 ●94
selected by
 
Best answer

You can solve your issue in two ways

  • You can use this formula Distinct( Table, Formula ).Result

     Distinct(Office,'OfficeCountry: Country/Region').Result

owerApps combobox distinct values

The office is my Sharepoint List and 'OfficeCountry: Country/Region' is the field that I want to display in the Compo

  • Or you can use this formula if you don't want to use the Result

       Distinct(Office.'OfficeCountry: Country/Region','OfficeCountry: Country/Region')

    owerApps dropdown list distinct values

deBUG Community deBUG.to
If you don’t ask, the answer is always NO!
...