In this post, we’ll work with a SharePoint List using The SharePoint Send HTTP Request action in Power Automate
we will see the most used methods, such as GET, POST, PATCH, and DELETE.
To access SharePoint resources using REST, construct a RESTful HTTP request by using the OData standard.
Method – Get
URL – https://{site_url}/_api/lists/getbytitle('{list_name}')/items
Accept – "application/json;odata=verbose"
In this window, please select the options as shown below.
Once GET request is executed, we need to do parse the response.
Take the result from preview step and generated JSON schema in Parse JSON.
The response body, which is in JSON format, we need to use apply to each action get a result from the previous step, and then we use Compose Action to get a specific result.
When we trigger the flow and see the result. Flow will get each item and display the Full Name, Email, and Employee Id as shown below.
Thank you..!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.