filter gallery by user email and status column

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Adrian_Celis 1,652 Moderator on at

Like (0)

Report
Copy link

Link copied!
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")

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
MohamedMo 87 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MohamedMo 87 on at

Like (0)

Report
Copy link

Link copied!

thanks but i need it to be dynamic by selected value
i have tried that but still gives me erorr

Was this reply helpful? Yes No
LukeShive 66 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

MohamedMo 87 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LukeShive 66 on at

Like (0)

Report
Copy link

Link copied!

Glad to hear that. Please mark solution.

Was this reply helpful? Yes No