Gallery Filter

(0) Share

Report

Posted on by Sharuk

202

Hi,

I'm having a gallery. i want filter all the products based on id and whose status is not ordered or dispatched from the datasource. but I'm not sure what i was doing wrong here. i'm getting all the products irrespective of status. below is the formula that i'm using

 Filter(orderProducts,Product_ID = SelectedProductID && (Status <> vStatus.ordered || Status <> vStatus.dispatched))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Powerplatform01 386 on at

Like (1)

Report
Copy link

Link copied!

You can watch this video to resolve your issue
https://youtu.be/bEVMhBW6vm0
Also use
Filter((orderProducts,Product_ID = SelectedProductID) && ((Status <> vStatus.ordered) || (Status <> vStatus.dispatched)))

Was this reply helpful? Yes No
Powerplatform01 386 on at

Like (0)

Report
Copy link

Link copied!

Please like the post and video if your issue is resolved 🙏

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Sharuk ,

If your Status is a Choice column, you can try this:

Filter(orderProducts,Product_ID = SelectedProductID && Status.Value <> "ordered",Product_ID = SelectedProductID && Status.Value <> "dispatched")

If your Status is a Text column, you can try this:

Filter(orderProducts,Product_ID = SelectedProductID && Status<> "ordered",Product_ID = SelectedProductID && Status<> "dispatched")

Or directly use your vStatus.ordered and vStatus.dispatched to compare with the value:

Filter(orderProducts,Product_ID = SelectedProductID && Status<> vStatus.ordered,Product_ID = SelectedProductID && Status<> vStatus.dispatched)

Best regards,

Allen

Was this reply helpful? Yes No