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:
  • 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 389

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard