cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MohamedMo
Helper II
Helper II

filter gallery by user email and status column

Hi All,

I have a gallery that filter user by their email, it works fine 

I need to add a filter in the same gallery to filter by status column from the drop-down box so once I add a filter it gives me an error so please how could I add more than one filter in my gallery 

as the below screenshot I need to filter by user email and status column

email.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

thanks for your response it worked with 
Filter(Approvelist,'Created By'.Email = User().Email && Status !Value= SearchDropdown.Selected.Value)

View solution in original post

7 REPLIES 7
Adrian_Celis
Super User
Super User

Hi @MohamedMo 

To add more filters, simply add as many as you like after your first filter using commas to separate. Example:

Filter(Approvelist,'Created By'.Email = User().Email, Status = "Approved")

 

VishuS
Resolver II
Resolver II

Hi @MohamedMo ,

Try below,

 

Filter(Approvelist,'Created By'.Email = User().Email, Status = DropDown.Selected.Value)

 

If the Status is Choice or lookup column then use,

Filter(Approvelist,'Created By'.Email = User().Email, Status.Value = DropDown.Selected.Value)

 

-------------------------------------------------------------------------------------------------------------------

If this post helps you to resolve the issue, please mark it as a solution/answer. it will helpful for future reference.

search.PNG

thanks for your response but it's not working as the screenshot

thanks but i need it to be dynamic by selected value 

i have tried that but still gives me erorr

search.PNG

LukeShive
Frequent Visitor

Remember that separators in PowerApps are language dependent If You want to filter gallery by both elements use &&

thanks for your response it worked with 
Filter(Approvelist,'Created By'.Email = User().Email && Status !Value= SearchDropdown.Selected.Value)

LukeShive
Frequent Visitor

Glad to hear that. Please mark solution.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,125)