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.

fig : Power Automate - Instant flow - "Update item" action from SharePoint - Error while updating list item - updating Reviewer column of type "Person and Group"
fig : Power Automate - Instant flow - "Update item" action from SharePoint - Error while updating list item - updating Reviewer column of type "Person and Group"

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
fig : SharePoint online - Demo list - "UpdatePerson" with column of type Person - single value
fig : SharePoint online – Demo list – “UpdatePerson” with column of type “Person and Group” – single value

  • We have one column “Reviewer” of type “Person or Group” as
fig : SharePoint online - Demo list - "UpdatePerson" with column of type "Person and Group" - single value
fig : SharePoint online – Demo list – “UpdatePerson” with column of type “Person and Group” – single value

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
fig : Power Automate - Instant flow - "Get item" action from SharePoint - Fetching list item from SharePoint list with ID 2
fig : Power Automate – Instant flow – “Get item” action from SharePoint – Fetching list item from SharePoint list with ID 2
  • 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
fig : Power Automate – Instant flow – “Update item” action from SharePoint – Updating list item from SharePoint list with ID 2 – updating Reviewer column of type “Person and Group”
  • As we tested flow we got an following error for updating column – “Reviewer” of type “Person and Group” as
fig : Power Automate - Instant flow - "Update item" action from SharePoint - Error while updating list item - updating Reviewer column of type "Person and Group"
fig : Power Automate – Instant flow – “Update item” action from SharePoint – Error while updating list item – updating Reviewer column of type “Person and Group”

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

fig : Power Automate - "Update item" action  - Updating "People and Group" field
fig : Power Automate – “Update item” action – Updating “People and Group” field
  • 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
fig : Power Automate - "Update item" action  - Updating "People and Group" field
fig : Power Automate – “Update item” action – Updating “People and Group” field

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 🙂

Prasham Sabadra

LIFE IS VERY BEAUTIFUL :) ENJOY THE WHOLE JOURNEY :) Founder of Knowledge Junction and live-beautiful-life.com, Author, Learner, Passionate Techie, avid reader. Certified Professional Workshop Facilitator / Public Speaker. Scrum Foundation Professional certificated. Motivational, Behavioral , Technical speaker. Speaks in various events including SharePoint Saturdays, Boot camps, Collages / Schools, local chapter. Can reach me for Microsoft 365, Azure, DevOps, SharePoint, Teams, Power Platform, JavaScript.

You may also like...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: