web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Distinct result of a c...

Power Apps

Answered

Distinct result of a combobox with filter

(1) Share

Report

Report

Posted on by Dive1

169

Hello I have a combox where the data that are showing is based on a dropdown

this is the code that I use on my combo box but I have a lot of duplicate data

Filter('public.w_encours_ors_tps_re'; code_agence = CodeAgence_1.Selected.Value)

So I wanted to add a distinc like this

Distinct(Filter('public.w_encours_ors_tps_re'; code_agence = CodeAgence_1.Selected.Value);no_or)

but it dont work it result in blank (no_or is the data I want in my combobox )

any idea why ?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Dive1 ,

Based on your description, I have made a test, but there are no mistakes.

Your code is correct, so I suggest you check whether there are items in “public.w_encours_ors_tps_re” that match the selected value of dropdown.

Collection “public.w_encours_ors_tps_re” :

Test:

Result:

In addition, please add ".Result" following the Distinct function to declare the column name, so it can be recognised easily by the Combo box Control.

Distinct(...).Result

Best regards,
Dive1 169 on at

Like
a
(0)

Report
Copy link

Link copied!

yes thanks it was because of the .Result that I was having nothing, that was not clear that I have to add a .Result because I didn't have errors when I don't add it

Join the conversation