Find all SharePoint sites a User has access to

(0) Share

Report

Posted on by CamCov

123

Hello,

I would like to create a flow that lists all SharePoint Sites a User has access to.

The Flow will be triggered from the onStart of a power app. This will run a cloud flow passing the users's email address to the flow.

I figured this could be done by sending an HTTP request, but I am struggling with the API call.

After retrieving the list of sites available to the user, return the info to the Power App for the user to see in a data table. It would be nice to retrieve the access level that the user has for each site as well, but not required.

Any examples or suggestions will be greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @CamCov

You could do the following steps:

1) Get all site collections in a Tenant. You can see the workflow here: Get All Site Collections Of Office 365 Tenant In MS Flow (c-sharpcorner.com)

2) For each site, you can check if the user has permissions using the "Send an HTTP Request to SharePoint":

Hope that helps!

Ferran

Was this reply helpful? Yes No
CamCov 123 on at

Like (0)

Report

@fchopo This is very close to what I need. This article only shows how to pull down site collections. I need to go one step further to the sites themselves.

To be clear, all of the sites located under the Active Sites page on SharePoint Admin Center ->

Also, within SharePoint Admin Center, how can I view all Site collections?

Was this reply helpful? Yes No
CamCov 123 on at

Like (0)

Report

@CamCov this was a silly question @fchopo sorry for the confusion. You directed me to the right place. I didnt realize SharePoint HTTP requests default at 100 entries returned. All better now!

Was this reply helpful? Yes No
ajeanjacket 15 on at

Like (0)

Report

Would this solution work based on a form submission trigger? I am trying to automate creating folders and dumping the form's attachments into different sharepoint libraries based on a particular question from the form.
Basically, there are different properties in my portfolio, each with a different teams channel/ SharePoint page. Based on the property the on-site team member fills the form out for, I would like the automation to populate the site address into the "create folder" and "create file" actions I have in my flow. I previously tried to copy the attachments scope I created and paste them into each switch case per property, but that caused too many actions. I hope this makes sense and appreciate the help!
@CamCov

Was this reply helpful? Yes No
Turreaux 6 on at

Like (0)

Report

I was able to mostly use your solution but I need to search for a specific user. Is there a way to specify which user rather than all users?

Was this reply helpful? Yes No