SharePoint Consulting Blog

Introduction

In this article, we will talk about how we can Create, Update and Delete data using “Send an HTTP request to SharePoint” Action in Power Automate.

Real-Life Business Use Case:

We all know with OOTB Power Automate action - “Send an HTTP request to SharePoint” we can perform SharePoint CRUD operations easily. However, sometimes, there are situations where we need to set up one flow for a different site. For this scenario, we need to pass Site URL and List Name Dynamically. At that time, we can use OOTB Power Automate action - “Send an HTTP request to SharePoint” and pass Site Name and List Name dynamically. In this article, we will see the most used methods, such as GET, POST, PATCH, and DELETE with examples.

Prerequisites:

• Log in to the flow portal with your Office 365 credentials.

• For this article, we have created two SharePoint List. One is for Training and the second List for PostData.

Overall Architecture/Schema of Lists:

Below is the column structure of the Training List.

Below is the column structure of the PostData List.

Now, let’s get started with development procedure!

Step 1:

Add Manual Trigger. We can choose trigger based on business need.

Step 2:

Initialize variables for site URL and list name.

Step 3: Get Items

Click on New Step and add an action “Send an HTTP request to SharePoint”.

Site Address: Choose your SharePoint Site from the dropdown.

Method: Select “Get”

Uri: _api/web/lists/getbytitle(“List Name”), other attributes like a top, filter, etc can be added here.

Step 4: Create Item

Add “Send an HTTP request to SharePoint” action.

Site Address: Choose your SharePoint Site from the dropdown.
Method: POST
Uri: _api/web/lists/getbytitle(“List Name”)
Headers: In the case of a post we need to add a header. In the Headers section, there is a key-value pair combination.

content-type :application/json;odata=verbose
If-Match : *

Body: JSON body as per business requirements.

 {  
 "__metadata": { "type": "SP.Data.PostDataListItem" },  
 "Title": "New Demo User Post",  
 "Score": 2 ,  
 "TrainingId": 4    
 }

Note: The body part will have a schema of the list item you want to create. Make sure you are including all mandatory columns in the schema. Now, run the flow and check the result.

Success code: 201 means our post method completed successfully. Now we will verify the SharePoint list to check.

Step 5: Update Item

To Update the existing item, we need to use Patch method. Add an Action “Send an HTTP request to SharePoint”.

Site Address: Choose your SharePoint Site from the dropdown.
Method: PATCH
Uri: _api/web/lists/getbytitle(“List Name”)(ItemID) , id of item which will be updated
Headers: In the case of a post we need to add a header. In the Headers section, there is a key-value pair combination.

content-type :application/json;odata=verbose
If-Match : *

Body: JSON Body as per the business requirements.

 {   
 "__metadata": { "type": "SP.Data.PostDataListItem" },   
 "Title": "New Demo",   
 "Score": 2 ,   
 "TrainingId": 4   
 }

Success code: 204 means we have successfully updated the specific list item. Now let’s verify the list item.

We can see that the User Department is updated to HR from IT for Demo User 1.

Step 6: Delete Item

Add an Action “Send an HTTP request to SharePoint” in our existing flow.

Site Address: Choose your SharePoint Site from the dropdown.
Method: DELETE
Uri: _api/web/lists/getbytitle(“List Name”)(ItemID) , id of item which will be updated
Headers: In the case of a post we need to add the header. In the Headers section, there is a key-value pair combination.