Unanswered

multifilter gallery based on people column

(0) Share

Report

Posted on by BHaapi

134

Hello! i have an approval app im working on that has 4 levels of approvals, i have built an interactive filter that i is working 3/4 times. the one im having issues with is that i want it to show everything that the user has to approve regardless of which step its in. my current code is such:

If(

varStatus = 1,

ApprovalCollection,

varStatus = 2,

Filter(

ApprovalCollection,

User().Email in 'First Approver'.Email,

User().Email in 'Second Approver'.Email,

User().Email in 'Specialty Approver'.Email,

User().Email in 'Final Approver'.Email

varStatus = 3,

ColApproved,

varStatus = 4,

colDeclined

)

the varStatus = 2 one is only showing the first criteria, not the collective criteria.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
hey @BHaapi

please try this:

If( varStatus = 1, ApprovalCollection, varStatus = 2, Filter( ApprovalCollection, User().Email in 'First Approver'.Email || User().Email in 'Second Approver'.Email || User().Email in 'Specialty Approver'.Email || User().Email in 'Final Approver'.Email ), varStatus = 3, ColApproved, varStatus = 4, colDeclined )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
BHaapi 134 on at

Like (1)

Report

i swear i did this, i must have missed something because it wouldnt format. Thank you so much!!

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

Its acting nuts somedays xD

Was this reply helpful? Yes No
BHaapi 134 on at

Like (0)

Report

directly related to this, do you know how to make a collection that would ONLY get what has their name in one of
the approver slots, then it would add to their collection, but if they are not mentioned in any of those, it would filter out.

User().Email in 'First Approver'.Email,
  User().Email in 'Second Approver'.Email,
  User().Email in 'Specialty Approver'.Email,
  User().Email in 'Final Approver'.Email

i know its probably a simple clearcollect(Approverslisted, Filter('purchase approvals', SOMETHING HERE))
but for the life of me i cannot seem to only collect the stuff that they are showing up in.

for additional context, the people who are first approvers should ONLY see things they are listed in, but the other 3 approval levels are upper management and would be able to see everything.

maybe this requires 2 collections based on the User().Email?

Was this reply helpful? Yes No