In this article, we will learn how to update the ‘Created By’ and ‘Modified By’ columns in SharePoint using Power Automate.

How to update SharePoint Created, Created By, Modified, Modified By Fields?

Step 1

Create Instant Cloud Flow and give name to flow.

Step 2

Add Send an HTTP request to SharePoint Actions to your flow.

Watch YouTube Video Tutorial

Update SharePoint Created, Created By, Modified, Modified by Fields

Step 3

Add your site address to the action.

Select POST inside the Method box.

Pass your Uri in Uri box as below.

_api/web/lists/GetByTitle('FlowTest')/items('1')/ValidateUpdateListItem

Pass the Header as below:

{
    "Content-Type": "application/json;odata=verbose"
}

Pass the Body as below:

{ 
"formValues":[ 
{ 
"FieldName":"Author", 
"FieldValue":"[{'Key':'i:0#.f|membership|youremail@yourdomain.com'}]" 
}, 
{ 
"FieldName":"Created", 
"FieldValue":"19/01/2000" 
}, 
{ 
"FieldName":"Editor", 
"FieldValue":"[{'Key':'i:0#.f|membership|youremail@yourdomain.com'}]" 
}, 
{ 
"FieldName":"Modified", 
"FieldValue":"21/01/2000" 
} 

] 
}

Step 4

Save your flow and run.