Filtering the dropdown

(0) Share

Report

Posted on by R Bakker

725

Screenshot 2020-02-15 14.46.20.png Screenshot 2020-02-15 14.47.39.png Hi again

With my purchasing app I have a screen where I can receive my orders as they arrive, but I would like to omit P.O numbers where all the product has arrived. In other words, if the quantities in the QuantityRO column are equal to QuantityO, then I want the corresponding order number to disappear in my dropdown. I can't seem to get my head around filtering dropdowns.

Thanks once again

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

WarrenBelz 153,061 Most Valuable Professional on at

Like (0)

Report
Hi @Corissandageri ,
I assume QuantityRO and QuantityO are numeric columns from your data source.
I will call your data source Purchases in this exercise.
So the Items property of the gallery would be
Filter( Purchases, QuantityRO <> QuantityO )
If they are other field types, this may need to be adjusted - please let me know.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 153,061 Most Valuable Professional on at

Like (0)

Report

Hi @Corissandageri ,
Just noticed it is a drop down - principle is the same.
Please give me the current Items property if you have not worked it out from the post below.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

I tried it, but I get no values showing now.
Items
Sort(Distinct(Filter(Table4,OrderNumO),QuantityRO <> QuantityO),Result)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,061 Most Valuable Professional on at

Like (1)

Report
Hi @Corissandageri ,
I just did a similar experiment on one of my bigger lists - the issue is the Distinct filter being non-delegable and I received no results.
I then did a collection on the list (you will need to get something filtered under 2000 items with a delegable filter). I will call the resulting collection Collect4 and the below should work
Sort( Distinct( Filter( Collect4, QuantityRO <> QuantityO ), OrderNumO ), Result, Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Na sorry that does not work either

Was this reply helpful? Yes No
WarrenBelz 153,061 Most Valuable Professional on at

Like (0)

Report

@Corissandageri ,
Thanks for testing, that was definitely on a collection form your data source?
I re-checked and I have a list using the same structure.
Do you get an error or simply no result?

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Hi @Corissandageri,

Could you share more error information?
I also made a test on the following codes, I think it can meet your needs and work well.

Sort(Distinct(Filter(Table4,QuantityO<>QuantityRO),OrderNumO),Result)

Please ensure the DisplayFields property is ["Result"].
If this doesn't meet your needs, please share more about your requirements.
If this doesn't work without any error, please create a new app and try again to check if the issue is fixed.
If there is any error message, please share it with screenshots.
Best regards,
Sik

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

My Apologies Warren, instead of rewriting your expression, I should of copied and pasted, then swap out the appropriate column names. Yours did work out after all. And thank you by the way.

Was this reply helpful? Yes No
WarrenBelz 153,061 Most Valuable Professional on at

Like (0)

Report

You can also accept mine if you think that was also the solution.

Was this reply helpful? Yes No