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 ?
This worked. God bless you. Thankyou so much for investing time and helping me.
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
Tried couple of times still getting not well formatted json error as shown in the above screenshot
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
Yes, the resource name column was by mistake set to multiple select, which I have now unselect.
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
I tried this but getting below error