filter gallery by user email and status column

[MohamedMo]

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

[Adrian_Celis]

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]

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.

[MohamedMo]

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

[MohamedMo]

thanks but i need it to be dynamic by selected value 

i have tried that but still gives me erorr

[LukeShive]

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

[MohamedMo · Accepted solution]

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

[LukeShive]

Glad to hear that. Please mark solution.