Unanswered

Filter a gallery based on user access

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I created a custom login form for my app. On my Login(SP1) I have a column for user access("User", "Lead"). I am trying to figure out how can I filter a Gallery(SP2) by user access.

For User: Gallery should be filtered by Projects assigned to him/her.

For Lead: Gallery should be filtered by projects (projects created by Users) assigned to her team.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

tchin-nin 779 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous So correct me if I'm wrong, you have 2 SharePoint Lists :
1- Login - collecting the list of users that can access the app with a notion of role : User/Lead. What is the data structure of this list ? 1 column type Person for the user, 1 column type Choice for the role and 1 column type Text for te Team ?
2- A list of items assigned to a user.

You want for a regular user to see only items assigned to him. And for a Lead to see all items assigned to a member of his team .

Another important question is how many items that list contains ?
You might have to work around delegation issues.

Théo

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @tchin-nin

For Login SP - Yes there are 2 columns, 1st is for User (type: Person) and the 2nd is for Lead (type: Choice)

Yes you are correct, "Regular user to see only items assigned to him. And for a Lead to see all items assigned to a member of his team"

Probably the list will contain less that 500 items. Hoping you can help me out.

Thanks.

Was this reply helpful? Yes No
tchin-nin 779 on at

Like
a
(1)

Report
Copy link

Link copied!

So in the Login SP, the choices for the Lead column are lead display names ?

You'll have to determine the user role OnStart or OnVisible property of your home screen. Then we'll be able to filter the gallery.
In my example :
Login is your role list in SP with User(person) and Lead(choice that contains DisplayName) columns
DataSource is the list of your items you want to filter with AssignedTo (person) column

Screen.OnVisible :
Set(currentUser,User()); //for better performances, I set a variable containing the current user. I'll use this variable instead of the User() function
Set(currentUserRole,If(!IsBlank(LookUp(Login,currentUser.FullName exactin Lead.Value,ID)),"Lead",!IsBlank(LookUp(Login,currentUser.Email exactin User.Email,ID)),"User")

Then your Gallery.Items :
Filter(DataSource,(currentUserRole = "User" && currentUser.Email exactin AssignedTo.Email) || (currentUserRole="Lead" && CurrentUser.FullName exactin LookUp(Login,AssignedTo.Email=User.Email,Lead.Value)))

Give it a shot, I haven't reproduce your exact case so tell me how it goes.

Théo

Was this reply helpful? Yes No