Unanswered

List all users of a SharePoint Site

(2) Share

Report

Posted on by Bungle is Lazy

Hi all, we have a requirement that I am hoping to implement, where by a button is made available to users on each SharePoint site we create, that when pressed will list all users who have access to that site. I cannot seem to find away (not sure if its possible) to have a Flow that will do it with out creating one for each site and specifying the Site id.
From doing a bit of research I can only find a way to create it for a specific Site, which is to time consuming, where as I hoping that when setting up the flow, and when it calls the Graph API I can return all users on that current SharePoint site they are sitting on when they press the button.

thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report
Your research is correct from my knowledge. You might be able to do this:

Create a flow that is manually triggered instant cloud flow.

Add an input for the group name.

Add the List groups action with a filter query where displayName eq 'Group Name from Trigger'

Add a condition to see if one group was found with that name.

If so, on the yes side use the List group members action with the Group ID from step 3.

The flow will look like this:

You can then give everyone access to run the flow. Of course, the users will need the appropriate licensing to run the flow and there will be a little more to it than this.

Was this reply helpful? Yes No
Suggested answer

Zdenka_Cech 101 on at

Like (1)

Report
Hi

this could be tedious task even for PowerAutomate, because:

there could be break permissions on a list or a single item

there could be shared links

there could be also office365 or security groups

So to itinerate all items and their permissions on a site could take 'ages' for powerautomate.

The best way I can suggest is to use third party tools such as Sharegate or SharePoint Manager Plus.

We did similar requirement to track permissions the Sharegate report can be scheduled and uploaded to the site for the owner review. It is quick also for large sites with over 10million files or xTB in size.

But if you want to simply list all users on the Site Permissions level only (note there could be group types like SharePoint, Office365, Security) you need to collect all the groups than check their type to use appropriate action to retrieve their members like in the answer by David earlier. Plus single user if added directly.

Anyway I guess they want to list all users having access anywhere on the site. So you maybe would like to try some third party tools.

I think you do not need to create for each site, to get siteID you can use the https Sharepoint request action or Graph API with the trigger site url. Here is one good tip: Get All Site Collections Of Office 365 Tenant In MS Flow

*Zdenka

Was this reply helpful? Yes No