Skip to main content

Notifications

Power Automate - General Discussion
Answered

Automated flow to update created by column

(0) ShareShare
ReportReport
Posted on by 24

I am trying to update auto generated "Created By" column to reflect value of "Resource Name" column of the same SharePoint list.

What I am doing wrong please ?

 

1000013742.jpg

 

 

  • Poojalodha Profile Picture
    Poojalodha 24 on at
    Re: Automated flow to update created by column

    This worked. God bless you. Thankyou so much for investing time and helping me.

  • Verified answer
    Re: Automated flow to update created by column

    Hi @Poojalodha ,

    You can put this code directly into the body:

    {
    	"formValues": [
    		{
    			"__metadata": { "type": "SP.ListItemFormUpdateValue" },
    			"FieldName":"Author",
    			"FieldValue":"[{'Key':'i:0#.f|membership|@{items('Apply_to_each')?['ResourceName/Email']}'}]"
    		}
    	]
    }

     Best Regards,

    Sunshine Gu

  • Poojalodha Profile Picture
    Poojalodha 24 on at
    Re: Automated flow to update created by column

    Tried couple of times still getting not well formatted json error  as shown in the above screenshot 

  • Poojalodha Profile Picture
    Poojalodha 24 on at
    Re: Automated flow to update created by column

    1000013762.jpg

  • Re: Automated flow to update created by column

    Hi @Poojalodha ï¼Œ

    That's right.

     

    Best Regards,

    Sunshine Gu

  • Poojalodha Profile Picture
    Poojalodha 24 on at
    Re: Automated flow to update created by column

    1000013754.jpg

  • Re: Automated flow to update created by column

    Hi @Poojalodha ,

    Have you changed the Resource Name column from a multi-select person column to a single-select person column?
    If so, refer to the information I provided above and recreate this flow.

     

    Best Regards,

    Sunshine Gu

  • Poojalodha Profile Picture
    Poojalodha 24 on at
    Re: Automated flow to update created by column

    Yes, the resource name column was by mistake set to multiple select, which I have now unselect.

     

    1000013750.jpg

     

  • Verified answer
    Re: Automated flow to update created by column

    Hi @Poojalodha ,

    Is your Resource Name column a multi-select person column?

    Please go to the editing interface and show me a screenshot of the parameters of the action in your flow.

    Like this:

    vyetonggumsft_0-1713937186814.png

    Best Regards,

    Sunshine Gu

  • Poojalodha Profile Picture
    Poojalodha 24 on at
    Re: Automated flow to update created by column

     

    I tried this but getting below error

     

    1000013747.jpg

     

     

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,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard