Extract users from SharePoint group

[Ashok2]

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 ?

[ekarim2020]

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]

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:

You could try a wild card search:

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