How to use Send an HTTP request to SharePoint in Power Automate?

Introduction

Send an HTTP request to SharePoint action is used to execute REST queries. As we know when we want to perform any operations in SharePoint then we are using APIs so in the flow, we can use fro the same requirements. For more details refer to working with send sp http request.

Implementation

We will create a SharePoint list and we will perform Create, Read, Update and Delete operations. we will create an instant flow. let’s see step-by-step implementation.  

1. Go to Power Automate > My flows > select New flow > Select instant cloud flow    2. Read items from To Do list. (Read Operation) So to perform the read operation we will use the GET method. Add Send an HTTP request to SharePoint action from + icon and here we need Site address, Method, and URI. Site Address: Select the Site URL in which we want to perform actions

Method: GET

Uri: _api/web/lists/getbytitle(‘To Do’)/items

Headers***:** Not required* You can also add URI in a variable because this we will need for all the actions.  If it will successfully execute it returns statusCode 200 and records in the body if records are available.   

3. Create item in To Do list (Create Operation) Site Address: Select the Site URL in which we want to perform actions

Method: POST

Uri: _api/web/lists/getbytitle(‘To Do’)/items

Headers***:** Need JSON object*

*  {
       “content-type”: “application/json;odata=verbose”,
       “accept”: “application/json;odata=verbose”
  }*

Body : RequestBody

*     {
         “__metadata”: {
               “type”: “SP.Data.To_x0020_DoListItem”
        },
       “Title”: “Demo Task1”,
       “Status”: “Started”
   }* In the request body, we need type so now the question is how to get type? It is SP.Data.{ListName}ListItem (replace {ListName} with list name. if space in between list name then it will be separated with _x0020_).  If it will successfully execute it returns statusCode 201.    4. Update item in To Do list (Update Operation) Site Address: Select the Site URL in which we want to perform actions

Method: PATCH

Uri: *_api/web/lists/getbytitle(‘To Do’)/items(itemID) *

Headers***: ***

*  {
      “content-type”: “application/json;odata=verbose”,
      “IF-MATCH”: “*”
}*

Body : RequestBody

*     {
         “__metadata”: {
               “type”: “SP.Data.To_x0020_DoListItem”
        },
       “Title”: “Task1”,
   }*

**  **

**  

5. Delete item in To Do list (Delete Operation) Site Address: Select the Site URL in which we want to perform actions

Method: DELETE

Uri: *_api/web/lists/getbytitle(‘To Do’)/items(itemID) *

Headers

{     \
      "content-type": "application/json;odata=verbose",\
      "IF-MATCH": "\*",\
      "X-HTTP-Method": "DELETE "\
}

Body: Not required *

Summary

In this article, we have seen the step-by-step implementation of CRUD operation of SharePoint list items using Send an HTTP request to SharePoint in Power automate. Hope this helps! Sharing is caring!