cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Filtering the dropdown

Screenshot 2020-02-15 14.46.20.pngScreenshot 2020-02-15 14.47.39.pngHi 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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

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.

View solution in original post

Highlighted
Community Support
Community Support

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)

 

Snipaste_2020-02-17_10-46-59.pngSnipaste_2020-02-17_10-46-25.png

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

View solution in original post

9 REPLIES 9
Highlighted
Community Champion
Community Champion

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.

Highlighted
Community Champion
Community Champion

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.

Highlighted
Helper III
Helper III

Re: Filtering the dropdown

I tried it, but I get no values showing now.

Items

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

Highlighted
Community Champion
Community Champion

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.

View solution in original post

Highlighted
Helper III
Helper III

Re: Filtering the dropdown

Na sorry that does not work either

Highlighted
Community Champion
Community Champion

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?

Highlighted
Community Support
Community Support

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)

 

Snipaste_2020-02-17_10-46-59.pngSnipaste_2020-02-17_10-46-25.png

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

View solution in original post

Highlighted
Helper III
Helper III

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.

Highlighted
Community Champion
Community Champion

Re: Filtering the dropdown

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

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,632)