Find all SharePoint sites a User has access to

[CamCov]

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!

[fchopo · Accepted solution]

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

[CamCov]

@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?  

[CamCov]

@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!

[ajeanjacket]

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 

[Turreaux]

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?