Answered

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:

Using Apps Using Formulas

All responses (4)

Answers (1)

BHaapi 134 on at

Like (0)

Report

Re: multifilter gallery based on people column

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?
mmbr1606 11,999 Super User 2025 Season 1 on at

Like (0)

Report

Re: multifilter gallery based on people column

Its acting nuts somedays xD
BHaapi 134 on at

Like (1)

Report

Re: multifilter gallery based on people column

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

mmbr1606 11,999 Super User 2025 Season 1 on at

Like (1)

Report
Re: multifilter gallery based on people column

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