Power Automate - How to update SharePoint Created, Created By, Modified, Modified By Fields?

This video explains how to update SharePoint system fields Created, Created By, Modified, Modified By.
REST API
_api/web/lists/getbyTitle('ajlist')/items({Here place the id of the record})/ValidateUpdateListItem
Header
Content-Type application/json;odata=verbose
Http Body
{
"formValues":[
{
"FieldName":"Author",
"FieldValue":"[{'Key':'i:0#.f|membership|[e-mail]'}]"
},
{
"FieldName":"Created",
"FieldValue":"19/01/2000"
},
{
"FieldName":"Editor",
"FieldValue":"[{'Key':'i:0#.f|membership|[e-mail]'}]"
},
{
"FieldName":"Modified",
"FieldValue":"21/01/2000"
}
]
}

[@jackieduarte3300]

Thanks, It worked for me.

[@abm4975]

You're welcome!

[@bharanidharan3074]

How to update values by dynamic content .. I tried it is now working by if I give mail manually it works

[@JoeAtWork-gy4wh]

Hi abm Is it possible to use a version of this flow to migrate a SPO classic List to a SPO Modern List in the same tenant? I have a few lists to move but I only need to retain the created data from the SPO Classic from the metadata.

[@abm4975]

Hi Joe Believe it should be possible. I can't see any difference other than the UI changes between classic and modern. So Power Automate should connect the classic list.

[@JoeAtWork-gy4wh]

@@abm4975 Thank you for your quick reply :) ShareGate charge $4999 a year for that ability so it would be a game changer if it could be done via a flow.

[@abm4975]

Interesting. Could you connect me via email. Check my Channel about section. I want to see the classic list. I could have a go and see whether I can make it work or not. Thanks

[@Digital_Nomad_Life]

What if I want to update the created by column of the same SharePoint list by using resources name column of that same list

[@alexeyvelasquez7070]

Any luck here? i need to do the same.

[@jayasreebandaru5003]

Thanks for the video. How can we achieve this if files are in the DocumentLibrary of Sharepoint? I need to update the modified date if the date is 2 years old.

[@abm4975]

Use the expression addYears() and filter the records using this value. learn.microsoft.com/en-us/power-automate/minit/date-and-time-operations Thanks

[@jayasreebandaru5003]

​@@abm4975 , thank you for the quick reply, yes. I am using addDays(utcNow,-913,’yyyy-MM-dd’) , UpdatefiePropertiecs does not update the Modified and SharePoint trigger Send HTTP Request, going wrong on POST or PUT to update

[@abm4975]

Hi I could offer a screenshare and have a look at your flow. Click my channel icon > Welcome to my Power Automate tutorial channel. Click here. You can see my email from the about section then connect me.

[@josemongebarquero3463]

How can I remove information from another column of a shared point list that is of type text?

[@abm4975]

Believe you are using Update Item Action step. Set it to null using the expression.

[@eshopeshop-rk7og]

Flow ran successfully... But the data not changed... May i know why?

[@abm4975]

I need to see the flow