PowerApps Gallery Filtering SharePoint Library Based on User Group Memberships

[Hari_Ree27]

Hi Everyone,

I have a SharePoint Document library in which i have a people picker field (AccessGroups) to allow multiple selection (Only Groups are added in it). Now i want to filter the library in PowerApps in such a way that if the current user is member of any one group (basically Departments) from the groups mentioned in the people picker field, those documents only should be visible to user.

For example in the below image, if the current logged user is a member of Account Group and All Company Members, then the user should only see Policy 2, Policy 3 and Policy 4. User should not be able to see Policy 1. 

Can anyone please help on this?

I tried filtering like below but it is showing blank Gallery. 

Filter('Test Library', User().Email in AccessGroup.Email) 

[EddieE]

@Hari_Ree27 

You could try using the Office365Groups connector and get a List of Groups the logged in User is a member of. Eg

Add this code to a button and review the created collection. This will show Groups you are a member of:

ClearCollect(
    colMyGroups_test,
    ForAll(Office365Groups.ListOwnedGroupsV3().value As groups,
            {
                groupName: groups.displayName
            }
    )
)

From there, you should be able to filter based on Group displayName in your gallery. I realise this is only part of the answer but if you need further help, let me know.

Connector details

https://learn.microsoft.com/en-us/connectors/office365groups/

[Hari_Ree27]

@EddieE  Thanks for the reply. I created a collection as suggested by you but the collection is showing only groups that i owned (i.e., I am the owner of those groups). It is not showing groups that I am a member of. I used V3 only.

ClearCollect(

    colUserGroups,

    ForAll(

        Office365Groups.ListOwnedGroupsV3().value As groups,

        {

            MyGroups: groups.displayName

        }

    )

);

And also can  you please let me know how to compare the group names with the groups from the AccessGroup field.. 

[EddieE]

@Hari_Ree27 

Try doing a CountRows on that collection, I think it has a Max return value count, ie

// put this on a label
CountRows(colMyGroups_test)

The documentation for V3 says it returns ' ... own and belong to.' so should return both, ie

My collection shows both for me.

The 2nd part is trickier. You'd need to get the Display Names of each group and check against that collection.

In an app I've built I do something similar in reverse. My process is

- Use Power Automate to get the Group IDs of 18 Groups I'm interested in

- I then hard code these Group IDs / GUIDs into a collection in my App OnStart

- Users use a People Picker ComboBox to select a person from our AD

- I then run a check to see which of the 18 Groups the selected person is a member of -  this users the selected person UPN and Email to check.

The process I've built is reasonably complex but I'm happy to share it if you think it'll help but like I said above, I'm kind of doing the reverse to what you are try to achieve.

[Hari_Ree27]

@EddieE I tried the CountRows and it is showing value as 3 which i Owned. V3 isn't working for me to fetch the group names which I am a member of. Is there any settings that need to be done or level of permissions that i need to get those details please guide me through.

[EddieE]

@Hari_Ree27 

I'm unsure why this isn't working for you, it just works for me without issue. Maybe there's something setup in your Tenant that needs adjusting but I wouldn't know what/where this is.

@v-jefferni would you have an idea of why the above connector is only returning 3 Owned Groups and not Member Groups for @Hari_Ree27 ?

[Hari_Ree27 · Accepted solution]

@EddieE  Just wanted to drop a quick note to express my gratitude for your support. I managed to achieve the desired outcome through a slightly different approach. Instead of fetching all the groups the user is a member of and searching for them in the Access Group field, I decided to take a different route. I utilized 

Office365Users.MyProfile().Department

to retrieve the user's department and then cross-checked if that department is listed among the display names of the Access groups. If it's found, the document shows up; otherwise, it stays hidden. While I still encounter some delegation issues, the solution is up and running for now. Thanks again for your help!

[EddieE]

@Hari_Ree27 

Nice work mate, and happy I could be of some assistance / inspiration 🙂 

It's nice also that you have .Department data available to use - the AD in our Org changes quickly and a lot so the AD is typically out-of-date and not something I can leverage in my work.

Happy PowerApping 🙂