How To Update Created/Modified By In SharePoint List Item Using Power Automate

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.


Similar Articles