Creating POST method in Power Automate

Table of content

• Creating POST method in Power Automate

POST is a request method supported by HTTP. The POST request method requests that a web server accepts the data enclosed in the body of the request message, most likely for storing it. POST method is used to send data to a server for the creation or to update the resource.

We will create a POST method in power automate that accepts the JSON object, inserts a new JSON object into the SharePoint list, and returns the ID of the inserted item.

The body should be our JSON object. We are using the following JSON object body:

{
"product": "Testing",
"price": 444,
"category": "Electronics"
}

Once the API call for the POST method is successful it will return the status code 200 OK.

• Before starting, we need to create a list on the SharePoint site.
  For a detailed explanation on SharePoint site list creation go to Actions Chapter.
• Create a list name Product List in your SharePoint site. We have few items already created in our SharePoint list.
  
  
• Go to Microsoft Power Automate. Sign in to your account.
  
  
• Click on Create and then click on Instant cloud flow.
  
• Name the Flow and click on Skip.
  
• Select When an HTTP request is received from Triggers.
  
• Select the method as POST. To generate schema click on Use sample payload to generate schema. We are generating schema so that we can access the properties of the JSON object.
  
• Enter JSON object and click on Done.
  
  
• Now, we have our schema generated through our JSON object. Click on the New step.
  
• Select Create item (SharePoint) from Actions.
  
• Enter the SharePoint site address and our Product List name. Add Title as product, Category as category, and Price as price from dynamic contents. Click on the New step.
  
  
• Select Response (Request) from actions.
  
• Status code is automatically generated with the value of 200. Click on add dynamic content.
  
• Select ID from dynamic contents.
  
• Click on Save.
  
• After clicking on Save, an HTTP URL will be generated. Go back to the HTTP trigger. Copy the HTTP POST URL.
  
  
• Go to the Postman site and Sign in to your account.
  
• Add the URL for the POST method.
  
  
• After adding the URL click on Body.
  
• In the Body section, select raw and JSON.
  
• Add the JSON object to the body and click on Send.
  
• Here, a new ID is generated for our object. We get status code 200 OK after the successful completion of our API call.
  
• Here, we have number 6 as ID generated in our SharePoint list.
  
  

I am Sharvari Raut, having sound knowledge and experience in technical writing. Currently, pursuing my B.Tech in Computer Science and Engineering.