How to eliminate duplicates in drop down in Power Apps

(0) Share

Report

Posted on by katgifford

For my Drop down box, I have the following in the Items formula:

"Filter(ShoeInventory,ProductCategory = ddByCtgy.SelectedText.ProductCategory)"

I want to be able to just show distinct values in the drop down list. I have attached a screenshot of how it currently displays.

I've tried following several videos for DISTINCT but can't get it to work with this drop down.

Thanks for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @katgifford ,

Could you please try using this formula? If any errors occur, could you kindly provide the error message?

Distinct(Filter(ShoeInventory,ProductCategory = ddByCtgy.SelectedText.ProductCategory),ColumnName)

Best Regards,

Bof

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @katgifford

To use the Distinct function, in the Items property of your drop down:
Distinct(ShoeInventory, ProductCatergory)

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
katgifford 6 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft Thanks. Just want to confirm I would update the "ColumnName" value to ProductCategory

Was this reply helpful? Yes No
katgifford 6 on at

Like (0)

Report
Copy link

Link copied!

@AARON_C Thanks for the attempt. Now my gallery doesn't show the images or price, etc. only the product category but I do only see one of each in the gallery

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @katgifford ,

Please try:

ForAll( Distinct(ShoeInventory,ProductCategory), LookUp(ShoeInventory,ProductCategory=Value) )

Best Regards,

Bof

Was this reply helpful? Yes No
katgifford 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft ,
I tried using that update and it still doesn't work. It doesn't give an error, the drop down still shows duplicates when I play the app.

Thanks.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@katgifford

But doesnt your dropdown only need to show the category of the shoe? You should be filtering the gallery based off the drop down.

Did you place the code into the dropdown control.

Was this reply helpful? Yes No