web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to change the Auth...
Power Automate
Unanswered

How to change the Author in the author column of Sharepoint list with Power Automate

(0) ShareShare
ReportReport
Posted on by 1,042

Hi,

I have made this flow to change the name of the author in the author column of a sharepoint list.

The flow runs but doesn't change anything. What am i doing wrong?

 

PeKi72_0-1654026898465.png

Gr. P

Categories:
I have the same question (0)
  • Verified answer
    RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    You're not doing anything wrong, as far as I am aware it's not possible to change the author.

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • CU16021406-1 Profile Picture
    1,042 on at

    Yes it is possible. My flow works now and changes the author or editor field. I had a syntax error in my JSON-code

    thank you for your response. Gr .P

  • Community Power Platform Member Profile Picture
    on at

    Hello Peki72,

     

    Can you please explain in detail that how to Change the author name in the author field in SP List. Can you please also share your corrected JSON format? Thank you

  • John1 Profile Picture
    5 on at

    Can you please post your working JSON as I've been struggling with this for months now. Many thanks!

  • Verified answer
    CU16021406-1 Profile Picture
    1,042 on at

    This is the solution:

     

    PeKi72_0-1667122866554.png

    Gr. P

     

  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    Thanks @PeKi72 this is really good, but I'm getting a "not well formed JSON" error. Could you possibly copy ad paste the body JSON code up here please so we can copy it (replacing anything you don't want us to see with xxxx). I've made some basic mistake somewhere but can't immediately see it.

     

    Rob
    Los Gallardos

  • CU16021406-1 Profile Picture
    1,042 on at

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

     

    Gr. P

  • CU16021406-1 Profile Picture
    1,042 on at

    The xxxx is the email-address from you or another person you which to change the picture from.

    The JSON code is for both the Author and Editor. And you have to specify in you Power Automate 

    flow the Row ID from the Sharepoint list where you want to change the picture. Gr. P

  • John1 Profile Picture
    5 on at

    Thanks for sharing your solution. 
    I was able to get this (and variations in other threads) working for both Author and Editor of a List, however only for Editor for a Library (including Site Pages).

    I suspect it's because Author is a read-only field, but then I would expect this to be consistent across both Libraries and Lists? In any case it's beyond my level to resolve, which feels like bitter defeat xD

     

    My use case is that I'm using POST to create site pages from a template, however, this also copies the Author and Created Date of the template. That poor person gets all the "Likes" and "Comments", and I'm trying to set Author to the person who runs the workflow (i.e. the owner of the news post, not the template).

  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    @John1 for the same reason as you I have wanted to change the Author of pages in the Site Pages library. Having tested it yesterday I can say that @PeKi72 's solution does work for the Site Pages library. However, I don't know if this works when you first create the page which is what I think you are trying to do. I suspect it has to be done immediately after the page is created which is what we will be doing via a JSON-formatted button on each item in the Site Pages library.

     

     

    The flow looks like this:

     

    1-Flow.png

     

    {
     "formValues": [
     {
     "FieldName": "Author",
     "FieldValue": "[{'Key':'i:0#.f|membership|p@{triggerBody()['number']}@xxx.co.uk'}]"
     },
     {
     "FieldName": "Editor",
     "FieldValue": "[{'Key':'i:0#.f|membership|p@{triggerBody()['number']}@xxx.co.uk'}]"
     }
     ],
     "bNewDocumentUpdate": true
    }

     

    The button is shown below, it's a single line of text column:

    0-SP-list.png

     

     

    Format the column in advanced mode and add the following JSON, changing the ID of the flow, the text you want etc.

    {
     "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
     "elmType": "button",
     "txtContent": "Change Author to Page Contact",
     "customRowAction": {
     "action": "executeFlow",
     "actionParams": "{\"id\": \"50097cde-b800-4c6c-ade9-95be7574f4e5\",\"headerText\":\"Change Author to Contact\",\"runFlowButtonText\":\"Go\"}"
     },
     "style": {
     "background-color": "#cf000f",
     "color": "white",
     "border-radius": "10px"
     }
    }

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard