Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Role based security with distribution list




I need to achieve a secutiry based authentication.

I created an app with the sharepoint list

I have to filter the gallery based on the user role like admin have to see the all the items in the gallery and the user have to see thier own items. 


I can be able to filter the own items in the gallery.

neeed to acieve the admin gallery 

I have to use the same gallery to filter the items 

using an admin DL(Distribution List) group we have to fileter the grallery


Please assist

Community Support
Community Support

Re: Role based security with distribution list

Hi @Naresh,


Which field from the SharePoint list that you would like to filter with, the author, or some other fields(field type)?

This could be done by the following way:

1. Create a collection to hold the Members within the Distribution List, for example:

Table({FullName:AdminName1, Email:EmailAddress1},
{FullName:AdminName2, Email:EmailAddress2},

2. Then under the Items property of the Gallery, filter the Gallery with the formula below (assuming using the author field 😞

Filter(SharePointList, Author.Email in AdminGroup.Email)

to workaround delegation, try the formula below:

Filter(AddColumns(SharePointList, "AuthorEmail", Author.Email), AuthorEmail in AdminGroup.Email)

Let me know if this works for you.




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IV
Helper IV

Re: Role based security with distribution list



Have to filter the browsergallery.

When the admin team members login, then the Admin user should see the items created by all the users.

At present I am filtering gallery on the author.(Like the user can view the items they have created)


Will be the below process helps me out or any limitation to achieve it.

Helpful resources

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!


Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.


Super Users Coming in August

We are excited for the next Super User season.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,542)