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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automated flow to upda...
Power Automate
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

 

 

Categories:
I have the same question (0)
  • Poojalodha Profile Picture
    24 on at

    1000013743.jpg

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @Poojalodha ,

    I did a test for your reference.

    ListB modified before:

    vyetonggumsft_0-1713932507121.png

    ListB modified after:

    vyetonggumsft_1-1713932507082.png

    In my scenario:

    vyetonggumsft_2-1713932507176.png

    vyetonggumsft_3-1713932507178.png

    Method: POST
     
    Uri: 
    _api/web/lists/GetByTitle('<ListName>')/items(<ItemID>)/validateUpdateListItem
     
    Body:
    {
        "formValues":[
    {
        "FieldName": "Author",
        "FieldValue": "[{'Key':'i:0#.f|membership|<author email>'}]"
    }
        ],
    "bNewDocumentUpdate": true
    }

    Best Regards,

    Sunshine Gu

  • Poojalodha Profile Picture
    24 on at

    The problem is that I don't want to update email id manually. I want it to pick up resource name or email from the column "Resource Name" of the same SharePoint list 

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @Poojalodha ,

    My SharePoint List Update before:

    vyetonggumsft_1-1713934819523.png

    My SharePoint List Update after:

    vyetonggumsft_3-1713934896397.png

    My Flow:

    vyetonggumsft_4-1713934974693.png

    Uri: 
    _api/web/Lists/GetbyTitle('<List Tttle>')/items(<Item ID>)/ValidateUpdateListItem
    
    Headers:
    {
     "Accept": "application/json; odata=verbose",
     "Content-Type": "application/json; odata=verbose"
    }
    
    Body:
    {
    	"formValues": [
    		{
    			"__metadata": { "type": "SP.ListItemFormUpdateValue" },
    			"FieldName":"Author",
    			"FieldValue":"[{'Key':'i:0#.f|membership|Resource Name Email'}]"
    		}
    	]
    }

    Best Regards,

    Sunshine Gu

  • Poojalodha Profile Picture
    24 on at

     

    I tried this but getting below error

     

    1000013747.jpg

     

     

  • Verified answer
    v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    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
    24 on at

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

     

    1000013750.jpg

     

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    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
    24 on at

    1000013754.jpg

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @Poojalodha ï¼Œ

    That's right.

     

    Best Regards,

    Sunshine Gu

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard