Filter Gallery Three Ways

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have a Gallery.

I need to filter said Gallery in three different ways.

1. If User is 'Associate' filter Gallery based on UserName
- Associate can only see their own data in Gallery.
2. If User is 'Supervisor' filter Gallery based on UserName and all subordinates there under
- Supervisor can see their own data and all 'Associates' assigned to them.
- My data source (SPList2 has a line item for each 'Associate' and a column for
'Supervisor'
- If User is HR no filter applied; HR user can see all data

I've gotten most of it to work using the following -

If(PositionFld.Text="Associate",
Filter(Collection1, AssociateFullName = User().FullName),
SortByColumns(Filter(Collection1,
StartWith(AssociateLastName,
AssociateLastNameFld.Text)),

"AssociateFullName"))

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Phineas ,

Firstly set the Default of AssociateLastNameFld to "" (empty string) and try this

SortByColumns( Filter( Collection1, Switch( PositionFld.Text, "Associate", AssociateFullName = User().FullName, "Supervisor", Supervisor = User().FullName, "HR", StartWith( AssociateLastName, AssociateLastNameFld.Text ) ), "AssociateFullName" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No