This post is about creating a manual flow to update an item in SharePoint using PATCH method of HTTP request.
You will need 3 details. The uri, metadata and the SharePoint column name.
To find metadata, enter this in your browser and search for
If your list has no space enter this https://companyname.sharepoint.com/sites/sitename/_api/web/lists/getbytitle(‘ListName’)
If your list has space in it enter this https://companyname.sharepoint.com/sites/sitename/_api/web/lists/getbytitle(‘List%20Name’)
Search for ListItemEntityTypeFullName
You will find your metadata search with SP.Data.LISTNAMEListItem
uri = _api/web/lists/getbytitle(‘List%20Name’)/items(1)
Where items(1) is the item whose ID = 1
content-type = application/json;odata=verbose
IF-MATCH = *
Body
{
“__metadata”: { “type”: “SP.Data.LISTNAMEListItem” },
“Employee_x0020_ID”: “12345”
}
Please refer to image below
If you liked the post, please share it with others 🙂