Filter gallery more than one conditions.

(0) Share

Report

Posted on by Chonnipa

Hi All,

I would need to some help from you, I'm looking for a solution to : I want to Filter gallery below using 2 conditions:
- Dropdown List : Department must match Department in Gallery but Dropdown List : Department = "All Department" show all data in Gallery
- Dropdown List : Status must match status in Gallery, but if Dropdown List : Status = "All Status" then display all information in Gallery.

filter gallery.PNG

Hopefully you can see what I mean. Thank you in advance for your help

Best Regards,
Chonnipa

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Bipin D365 971 on at

Like (0)

Report
Copy link

Link copied!
Hi @Chonnipa ,

You can try below code.
Filter( myCities1, If( Dropdown2.Selected.Result = "All", true, City = Dropdown2.Selected.Result ), If( Dropdown3.Selected.Result = "All", true, Continent = Dropdown3.Selected.Result ) )

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No