Using AuthorID to edit Author field in another sharepoint list

(0) Share

Report

Posted on by Calcioscacchi

413

Hi guys.

I've copied elements from a sharepoint list (call it SourceList) to another (DestList) with a simple flow. and it works fine.

As u know, in DestList the author as the creation_datetime are not sync cause they depend from the owner of the flow.

I found this video to edit this fields:

(3) Get and update SharePoint list item using Power automate Http REST call l Parse Json l MS Flow - YouTube

but i'm facing a problem with the POST Method. As Author, I have the AuthorID property and it seems that the body of my HTTP request is not legit.

Actually i saved correctly the AuthorId of the SourceList in a variable, this is how I set the request:

I tried also:

But its not working.

Some suggestions?

Thanks.

I have the same question (0)

All responses (4)

Answers (1)

Anchov 1,984 on at

Like (0)

Report

Re: Using AuthorID to edit Author field in another sharepoint list

It looks like you have inconsistent use of quotes in your Body (in both screen shots). I have used double quotes successfully in:

In the past I have used a JSON validator to help catch these syntax errors. (JSON Online Validator and Formatter - JSON Lint)

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like (0)

Report

Re: Using AuthorID to edit Author field in another sharepoint list

I've tried with your solution but still not working.
Beside syntax errors, I think that my configuration doesn't reach the AuthorId field, maybe this field is in ReadOnly mode? Some hints to set this field editable?

Was this reply helpful? Yes No
Anchov 1,984 on at

Like (0)

Report

Re: Using AuthorID to edit Author field in another sharepoint list

Yes, AuthorID is a system field, and it cannot be written to without unlocking it first. While I haven't personally tried this, you may want to explore the solution provided in the link here:
Update the Created By (AuthorID) Field of a ShareP... - Page 2 - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Verified answer

Calcioscacchi 413 on at

Like (0)

Report

Re: Using AuthorID to edit Author field in another sharepoint list

I've tried it but I have no so much knowledge to manage the errors that I met applying this method to my lists.
I find a workaround creating 2 columns called "AkaAuthor" and "AkaCreationDate", then I use the POST method on them and I have the informations I need.

Was this reply helpful? Yes No