Create SharePoint List Item using HTTP request

This blog explains how to create Item in SharePoint List using HTTP request in Power Automate.

Steps to be followed:
  1. Select “Send an HTTP request to SharePoint” from Actions.
  1. Enter below details:

Site Address: Select the site address from the list. (or you can add from Dynamic content)

Method: POST

Uri: _api/web/lists/GetByTitle(‘Display Name of List’)/items

Example: _api/web/lists/GetByTitle(‘Leads’)/items

Header:

Accept : application/json;odata=verbose
Content-Type : application/json;odata=verbose

Body:

{
  "__metadata": {
    "type": "SP.Data.LeadsListItem"
  },
"FullName": "Vaishali S Vyas",
 "Title": "Follow-up with information regarding our promotions (sample)",
"Description":"This record is created for testing purpose",
"LeadType":"Cold"
}

NOTE:

  • Here FullName, Title, Description, and LeadType are the internal name of columns.
  • To create a list item you have to enter the internal name of columns in the body.

Running the Flow:

Leave a Reply

Your email address will not be published. Required fields are marked *