cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Corissandageri
Level: Powered On

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

7 REPLIES 7
WarrenBelz
Level 8

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.

WarrenBelz
Level 8

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.

Corissandageri
Level: Powered On

Re: Filtering the dropdown

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

Items

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

WarrenBelz
Level 8

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.

Corissandageri
Level: Powered On

Re: Filtering the dropdown

Na sorry that does not work either

WarrenBelz
Level 8

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?

Microsoft v-siky-msft
Microsoft

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

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,088)