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

All responses (9)

Answers (2)

WarrenBelz 146,620 Most Valuable Professional on at

Like (0)

Report

Re: Filtering the dropdown

You can also accept mine if you think that was also the solution.
R Bakker 725 on at

Like (0)

Report

Re: Filtering the dropdown

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

v-siky-msft on at

Like (1)

Report
Re: Filtering the dropdown

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
WarrenBelz 146,620 Most Valuable Professional on at

Like (0)

Report

Re: Filtering the dropdown

@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?
R Bakker 725 on at

Like (0)

Report

Re: Filtering the dropdown

Na sorry that does not work either
Verified answer

WarrenBelz 146,620 Most Valuable Professional on at

Like (1)

Report
Re: Filtering the dropdown

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.
R Bakker 725 on at

Like (0)

Report

Re: Filtering the dropdown

I tried it, but I get no values showing now.
Items
Sort(Distinct(Filter(Table4,OrderNumO),QuantityRO <> QuantityO),Result)
WarrenBelz 146,620 Most Valuable Professional on at

Like (0)

Report

Re: Filtering the dropdown

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.
WarrenBelz 146,620 Most Valuable Professional on at

Like (0)

Report
Re: Filtering the dropdown

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.