Updating Created By Column in SharePoint from csv file

(1) Share

Report

Posted on by SM-10101233-0

I have a flow built that imports a csv file into a SharePoint list. The flow works fine but I need to add something that updates the 'created' by column to the data held within the csv file and not my details after I have imported the file. I have searched online and can't find anything that so far has worked. Grateful for any help.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

You cannot change the Created By, you will have to create another column and insert their details from your file there.

Was this reply helpful? Yes No
SM-10101233-0 10 on at

Like (0)

Report
Copy link

Link copied!

I have managed to create another flow that updates the created by column using 'Sent HTTP request'. I can update a row based on Item. What I would want to do is update based on another field like 'Current Owner'. Does anyone know if that is possible?

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Just specify the Current Owner's email address in the HTTP action. (If its a person column use the dynamic content to select the email address, it will have an name something like "Current Owner Email").

{ "formValues": [ { "FieldName": "Author", "FieldValue": "[{'Key':'i:0#.f|membership|<email-address>'}]" } ], "bNewDocumentUpdate": true }

See: How to Easily Change the Creator or Editor of a SharePoint File or List Item Using Power Automate – Ellis Karim's Blog

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
SM-10101233-0 10 on at

Like (0)

Report
Copy link

Link copied!

That doesn't work. The only method that does work is using Item. However, that only updates one item at a time. Not practical is you have 100's to update.

I have tried to update to below (fileld_11) is the current owner column.

_api/web/lists/GetByTitle('InformationAssetRegister')/field_11('@email.com')/ValidateUpdateListItem

The following error appears.

Cannot find resource for the request field_11.
clientRequestId: 7f18abfa-8263-4951-8691-926a50de218e
serviceRequestId: 7b065ca1-d07a-a000-3883-0c9e8a6f53f5

Does anyone know how you can update multiple items? Please help :-)

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please see the following method: Batch Update, Create, and Upsert SharePoint Lists

Ellis

https://elliskarim.com

Was this reply helpful? Yes No
SM-10101233-0 10 on at

Like (0)

Report
Copy link

Link copied!

I don't think that will work. The issue is I'm trying to update the 'Created by' column (based on another field). I can get a flow to work if I update another field. The issue is when I update the 'Created by' column.

Does anyone have a working flow that will update the 'Created by' column with the details from another column?

Was this reply helpful? Yes No
SM-10101233-0 10 on at

Like (0)

Report
Copy link

Link copied!

I have been following this method which works for other columns but not created by. I have used the same format (people and group) but without success. Grateful if anyone can help.

Get and update SharePoint list item using Power automate Http REST call l Parse Json l MS Flow (youtube.com)

{"odata.error":{"code":"-2147467261, System.ArgumentNullException","message":{"lang":"en-US","value":"Value cannot be null.\r\nParameter name: formValues"}}}
clientRequestId: b5de849f-4ba7-43a7-b8fc-fe22580c34e6
serviceRequestId: acc25ca1-2044-a000-3883-046a06fec5b8

Was this reply helpful? Yes No
Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please provide more information and sample data from your source CSV file .

I'm not clear what you mean by "The issue is I'm trying to update the 'Created by' column (based on another field)".

Please provide more details about the other field; it is an email address, a SharePoint person column?

If you tried the tutorial below, please provide a screenshot of the error along with the flow.

How to Easily Change the Creator or Editor of a SharePoint File or List Item Using Power Automate – Ellis Karim's Blog

Ellis

Was this reply helpful? Yes No