Skip to main content
1 of 3
Matiur Rahman
  • 2.7k
  • 2
  • 7
  • 8

Here are the steps and a sample Power Automate you can use to suit your need.

  1. Get all the SPO groups (Id, Title) using [Send an HTTP request to SharePoint]
  2. Use [Parse JSON] to convert output (body) from step 1 to easily readable properties
  3. Use [Apply to each] to process each group and then retrieve users for that group by using another [Send an HTTP..]
  4. Use another [Apply to each] within the previous one to process each user
  5. Use [Parse JSON] to convert user object to easily readable properties
  6. Store Group Name, User Title and Email in variables and then append those to an array variable
  7. Create a CSV table using [Create CSV table] action with the data stored in the array variable

enter image description here

Matiur Rahman
  • 2.7k
  • 2
  • 7
  • 8