Answered

Automated flow to update created by column

(0) Share

Report

Posted on by Poojalodha

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 ?

I have the same question (0)

All responses (14)

Answers (2)

Poojalodha 24 on at

Like (0)

Report

Re: Automated flow to update created by column

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Re: Automated flow to update created by column

Hi @Poojalodha ,

I did a test for your reference.

ListB modified before:

ListB modified after:

In my scenario:

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

Was this reply helpful? Yes No
Poojalodha 24 on at

Like (0)

Report

Re: Automated flow to update created by column

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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Re: Automated flow to update created by column

Hi @Poojalodha ,

My SharePoint List Update before:

My SharePoint List Update after:

My Flow:

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

Was this reply helpful? Yes No
Poojalodha 24 on at

Like (0)

Report

Re: Automated flow to update created by column

I tried this but getting below error

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report

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:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Poojalodha 24 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Poojalodha 24 on at

Like (0)

Report

Re: Automated flow to update created by column

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Re: Automated flow to update created by column

Hi @Poojalodha ，

That's right.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No