Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

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 Team
Community Support Team

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.
Level: Powered On

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


Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,106)