Power Automate – small tips and tricks – updating / patching – single value person column in SharePoint list – Resolving error – The specified user {“@odata.type”: “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser”,”Claims”:”i:0#.f|membership| Email of user} could not be found.

Hi All,

Greetings for the day!!!

Today I learned something new so thought to share. SHARING IS CARING 🙂

Background

• We have SharePoint list and for our one of the requirement we are implementing Power Automate on the list
• We need to update list column of type “Person and Group“

SharePoint list details

• For demo purpose I created sample list “UpdatePerson” in my local tenant as

• We have one column “Reviewer” of type “Person or Group” as

Power Automate details

• We were working on Power Automate and one of the action is “Update Item” from “SharePoint“
• For Demo purpose we created “Instant cloud flow” so that we can test it manually
  • flow name – “Demo Updating SharePoint Person and Group field”
• We have “Get item” action from SharePoint as

• Next, we are adding “Update item” action from “SharePoint” to update the respective fetched item as shown in below fig
• For “Reviewer” column we have used “Reviewer” value from “Dynamic content” pane

• As we tested flow we got an following error for updating column – “Reviewer” of type “Person and Group” as

Error – The specified user is could not found with status – 400

{
“status”: 400,
“message”: “The specified user {\”@odata.type\”:\”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser\”,\”Claims\”:\”i:0#.f|membership|prasham1@knowledgejunction1.onmicrosoft.com\”,\”DisplayName\”:\”Prasham1 Sabadra\”,\”Email\”:\”prasham1@knowledgejunction1.onmicrosoft.com\”,\”Picture\”:\”https://knowledgejunction1.sharepoint.com/sites/Demo/_layouts/15/UserPhoto.aspx?Size=L&AccountName=prasham1@knowledgejunction1.onmicrosoft.com\”} could not be found.\r\nclientRequestId: f6f60900-bcc7-41d1-9a0b-876354e413c7\r\nserviceRequestId: f6f60900-bcc7-41d1-9a0b-876354e413c7″
}

The specified user {“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser”,”Claims”:”i:0#.f|membership|prasham1@knowledgejunction1.onmicrosoft.com”,”DisplayName”:”Prasham1 Sabadra”,”Email”:”prasham1@knowledgejunction1.onmicrosoft.com”,”Picture”:”https://knowledgejunction1.sharepoint.com/sites/Demo/_layouts/15/UserPhoto.aspx?Size=L&AccountName=prasham1@knowledgejunction1.onmicrosoft.com”} could not be found.
clientRequestId: b9638be6-20d7-4465-aac9-eb041d97dcc4
serviceRequestId: b9638be6-20d7-4465-aac9-eb041d97dcc4

Solution

• In Power Automate, in “Update item” action for “Reviewer Claims” field we need to specify value – “Reviewer Email” from “Dynamic Content” pane as

• Test the flow, will get succeeded
• Also one observation is sometime this didn’t works in this case prefix “i:0#.f|membership|” along with “Email” value as

Thanks for reading !! If its worth at least reading once, kindly please like and share !!! SHARING IS CARING 🙂

Enjoy the beautiful life !! Have a FUN !! HAVE A SAFE LIFE !! TAKE CARE 🙂