Skip to main content

Notifications

Power Automate - General Discussion
Answered

Using AuthorID to edit Author field in another sharepoint list

(0) ShareShare
ReportReport
Posted on by 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:

 

Calcioscacchi_0-1701102685757.png

 

 

I tried also:

Calcioscacchi_1-1701102724494.png

 

 

 

But its not working. 

Some suggestions?

Thanks.

 

  • Verified answer
    Calcioscacchi Profile Picture
    Calcioscacchi 413 on at
    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.

  • Anchov Profile Picture
    Anchov 1,984 on at
    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)

  • Calcioscacchi Profile Picture
    Calcioscacchi 413 on at
    Re: Using AuthorID to edit Author field in another sharepoint list

    Calcioscacchi_1-1701166704027.png

     

     

    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?

     

  • Anchov Profile Picture
    Anchov 1,984 on at
    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:

    Anchov_0-1701104976589.png

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard