Power Platform : Power Automate – calling SharePoint REST API

Hi All,

Greetings for the day!!!

Again small article – since I need to call SharePoint REST API from multiple different Power Automate so thought why not separate article on the same

Background :

• In our project we have an requirement to send an email to users of SharePoint groups / members of SharePoint group from Power Automate
• We have REST API to get the users from SharePoint group / members of SharePoint group – _api/web/sitegroups(6882)/users – here number in sitegroups is – Group Membership ID
• So we need to call REST API from Power Automate and get the users email ids

Calling REST API from the Power Automate / How to call SharePoint REST APIs from Power Automate :

• To call the REST API from Power Automate we have an HTTP operation action – “Send an HTTP request to SharePoint“
• “Send an HTTP request to SharePoint” this action allows us to invoke SharePoint REST API
• This action return results in JSON format

Demo :

• Lets create a new – instant cloud flow – “Demo__RESTAPI_call”
• For demo purpose we will trigger flow manually

• As we create flow manually, we will add an action “Send an HTTP request to SharePoint” from HTTP operation

• As in below fig, Power Automate provide us sample template / sample values

• Lets call the simple REST API to fetch all the items of Document library – _api/web/lists/getbytitle(‘Documents’)/items

• As we specify respective following details, we are ready to test the flow
  • Site Address
  • Method
    • GET
  • REST API Uri – here, _api/web/lists/getbytitle(‘Documents’)/items
  • Header is optional

• Lets test the flow
• From right top corner – there is link – “Test” as shown in below fig

• As we click on “Test” link, we will have right pane – “Test Flow” – will open with following options
  • Manually
  • Atomically
• For time being, we will go with “Manually” option
• At the bottom there is “Test” button, click on it

• On click of “Test” button we will have next pane – “Run flow” with option to start the flow
• At bottom there is button “Run flow“, click on it to proceed with flow

• On successfully execution of flow, could see the flow execution details as in below fig

• We get the REST API result in JSON format as shown in below two figs

• Note : How to parse this required JSON format and get the required values – we will discuss this in next article
• We can also check the result from browser
• Hit the respective REST API in browser as – <SharePoint site>/_api/web/lists/getbytitle(‘Documents’)/items

Complete flow:

Thanks for reading the article !!! Please feel free to discuss in case any issues / suggestions / thoughts / questions

HAVE A GREAT TIME AHEAD !!!