Restrict rows in gallery based on user's membership in Active Directory group

(0) Share

Report

Posted on by pennyland

192

Is it possible to restrict users to ONLY be able to see records in a gallery if they are in an AD group?

The backend data is coming from Excel and not a Sharepoint List, in case that matters.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

I mean if you restrict the document with the AD group then you will only see it if you're in that group because you won't have access to the excel document. You can also use the DatasourceInfo to read / show a gallery if they have read/write permissions to the datasource etc.
DataSourceInfo function - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

You can utilize Office 365 Groups connector if for some reason you can't secure the file by group and want the app to look it up by using:

!IsEmpty(Filter(Office365Groups.ListGroups().value,displayName = "Group Name"))

This will return True if they have the group in their list which means they are in it. etc.

Was this reply helpful? Yes No
pennyland 192 on at

Like (0)

Report

I will try that! Thank you! Stay tuned. 🙂

Was this reply helpful? Yes No
pennyland 192 on at

Like (0)

Report

I need multiple filters I guess. I only want to show certain records if they are in group1, and only other records if they are in group 2. I can use Office365groups as that has been set up as well.

Thanks again for your help!

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

Yeah, you would have to have your filter be something like Filter(Excelfile, ('Column to limit by' = 'value' && !IsEmpty(Filter(Office365Groups.ListGroups().value,displayName = "Group Name"))) || ('Column to limit by' = 'value2' && !IsEmpty(Filter(Office365Groups.ListGroups().value,displayName = "Group Name2"))) and so forth assuming you had a specific column that would be tied to a group. This way you show records only that are equal to that AND they are in a certain AD group.

Was this reply helpful? Yes No