cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ashok2
Post Patron
Post Patron

Extract users from SharePoint group

Hi All

I want to extract a list of users  from each Sharepoint group in Sharepoint sites   and export them in excel , i know that we can user rest api call for particualr groups but how to get all groups and list of users inside it ?

 

 

2 REPLIES 2
ekarim2020
Super User
Super User

Please see video tutorial: Power Automate get SharePoint Group Members & flow code snippets

This video goes through a step-by-step tutorial of how to get users/members from a SharePoint group.

 

 

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

ekarim2020
Super User
Super User

Try Graph Explorer to see if there is an API that will get a list of all the sites: Graph Explorer - Microsoft Graph

There appears to be a search for a SharePoint site by keyword:

ekarim2020_1-1630578846765.png

You could try a wild card search:

ekarim2020_0-1630578740608.png

 

https://developer.microsoft.com/en-us/graph/graph-explorer?request=sites%3Fsearch%3D*&method=GET&version=v1.0&GraphUrl=https://graph.microsoft.com

 

I have only just started to explore Graph Explorer - if you forgive the pun.

Ellis

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,582)