This blog explains how to create Item in SharePoint List using HTTP request in Power Automate.
Steps to be followed:
- Select “Send an HTTP request to SharePoint” from Actions.
- 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:
