Unanswered

get all sharepoint users from all sharepoint sites

(0) Share

Report

Posted on by Alyssableize101

Hello,

how can I retrieve a list of all Sharepoint sites with the correct users that have permission to the Sharepoint sites?

I can retrieve the users for one site, but I don't know how to loop through all Sharepoint sites.

Screenshot 2023-02-01 165348.png

can somebody please help me

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @Alyssableize101 ,

Please take a look at this post.

https://stackoverflow.com/questions/51616560/sharepoint-get-all-sites-and-all-sub-sites-using-sharepoint-online-rest-api

I believe it will list all the sites you have access to.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Alyssableize101 4 on at

Like (0)

Report

Hi @v-xiaochen-msft
Thanx for your response!
I looked at your link, but I think I found a easier solution.
I used the https:// [name}-admin.sharepoint.com, where I add the Site Address.
Now I can loop through all Sharepoint sites, but now I need to loop through all Sharepoint sites and then another for each loop through all Sharepoint users.
So one step closer, but not there yet

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Alyssableize101 ,

Which action in Flow calls the API you provided in your reply? I used the Api you provided but it failed.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Alyssableize101 4 on at

Like (0)

Report

Hi @v-xiaochen-msft ,

I think your API call is fine, but you need to be Sharepoint Administrator.
Otherwise the run is going to fail.

So I figured out that with this API call, I can get all Sharepoint sites with all the "site owners" and "created by".
I also need all role assigments from all user (see the second picture)
I don't know how to loop through all Sharepoint sites, Sharepoint users and the RoleAssignments.
Do you know how to do this?

Was this reply helpful? Yes No