How to easily change the Creator or Editor of a SharePoint File or List Item using Power Automate

We can easily change the Created By (Author) and/or the Modified By (Editor) properties of a SharePoint file or item. For example, you have created a file using your own account (perhaps via a Flow) which means that you are now the owner of that file. If you look at the SharePoint column called Created it shows you as the owner of that file.

If you look at the SharePoint column called Created it shows that you are the owner of that file.

You now want to change the owner of that file to another user. Or perhaps you want to change who last modified or changed that file to another user.

Using a HTTP request we can update the Created By column (Author) and/or the Modified By column (Editor) of a SharePoint file or list item. We can even change the Author or Editor properties of Folders too. We just need to specify:

  • Method: POST
  • SharePoint List Name
  • SharePoint Item ID
  • Author’s email address and/or Editor’s email address
Using a HTTP request we can update the Created By column (Author) and/or the Modified By column (Editor) of a SharePoint file or list item.
In the example above the List name is ‘Another Demo Library’. The item ID was selected from dynamic content. The Author and Editor will be set to Alex Wilber AlexW@365.com

Change both the Author and Editor:

_api/web/lists/GetByTitle('<ListName>')/items(<ItemID>)/validateUpdateListItem

{
  "formValues": [
    {
      "FieldName": "Author",
      "FieldValue": "[{'Key':'i:0#.f|membership|AlexW@365.com'}]"
    },
    {
      "FieldName": "Editor",
      "FieldValue": "[{'Key':'i:0#.f|membership|AlexW@365.com'}]"
    }
  ],
  "bNewDocumentUpdate": true
}

or change just the Author only:

_api/web/lists/GetByTitle('<ListName>')/items(<ItemID>))/validateUpdateListItem

{
  "formValues": [
    {
      "FieldName": "Author",
      "FieldValue": "[{'Key':'i:0#.f|membership|AlexW@365.com'}]"
    }
  ],
  "bNewDocumentUpdate": true
}

Remember to replace the <ListName>, <ItemID> and Author and/or Editor email address AlexW@365.com in the code above.

Example runtime output:

The owner and editor for item 75 was changed to Alex Wilber!
The owner and editor for item 75 was changed to Alex Wilber.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Built with WordPress.com.

Up ↑

%d bloggers like this: