Introduction
In this article, I will show you how to update created by and modified by value of a SharePoint list item.
Sometimes we are required to change the created by and/or modified by value of a SharePoint list. We can easily update value of both these fields using power automate.
Steps
Step 1
Create Power Automate Flow.
Step 2
Add Send an HTTP request to SharePoint Actions to your flow.
Step 3
Add your site address to the action.
Step 4
Select POST inside the Method box.
Step 5
Pass your Uri in Uri box as below.
Example : _api/web/lists/GetByTitle('FlowTest')/items('1')/ValidateUpdateListItem
Step 6
Pass the Header as below:
{
"Content-Type": "application/json;odata=verbose"
}
Step 7
Pass the Body as below:
{
"formValues": [{
"FieldName": "Author",
"FieldValue": "[{'Key':'i:0#.f|membership|[email protected]'}]"
}, {
"FieldName": "Editor",
"FieldValue": "[{'Key':'i:0#.f|membership|[email protected]'}]"
}]
}
Note
Change your user in Key.
Step 7
Save your flow and run.
Output:
Conclusion
This is how we can easily update created by and modified by of a SharePoint list item.