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 🙂
You must log in to post a comment.