Microsoft Flow - Get Members of a Security Group

I recently designed a complicated Approval workflow for a client and decided to stress-test Microsoft Flow to see how well it worked for this scenario. The outcome; approval workflows can get messy fast! Oh, and Microsoft Flow is a pretty neat tool :D

Even though Flow functionality is improving regularly, some functions required HTTP requests to SharePoint APIs, including how to get members of a Security Group. Here's how its done:

1. Add a 'Send an HTTP request to SharePoint' action with the following values:
   1. Site Address: Your site address
   2. Method: GET
   3. Uri: /_api/web/sitegroups/getbyname('YOURGROUPNAME')/users?$select=Email
2. Next, we need to parse the response into a format that Flow can interpret. Add a 'Data Operations - Parse JSON' action with the following values:
   1. Content: The 'Body' from your previous HTTP request action
   2. Schema: If you're like us and are only interested in the Email addresses of the group members, you can use the schema at the end of this post
3. Now you can use an 'Apply to each' action to do something with each member's Email Address. 

​Enjoy!

Schema