Hi, I'm getting the following error message on the Start_an_approval step:
The request failed. Error code: 'GraphLookUpRequestFailedError'. Error Message: 'User lookup request to Graph failed lookup for user identifier: '{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|-----.-----@-----.com","DisplayName":"------, -----","Email":"-----.-----@-----.com","Picture":"https:/'.'.
(actual data was replaced with '-')
The Start_an_approval step is configured as follows:
I'm guessing that the error message results from the "Assigned to" field, but the error message included the correct email address and user name. This used to work fine when the email address was hardcoded and there was no need for a lookup.
I am getting this error for myself as the creator of a SharePoint list item which is then being assigned to the person/sharepoint user in a specific field on the list. Not clear why I would get this error as the creator of the item on the SP list when all the connectors are valid?
{
"host": {
"connectionReferenceName": "shared_approvals",
"operationId": "CreateAnApproval"
},
"parameters": {
"approvalType": "CustomResponseAwaitAll",
"ApprovalCreationInput/responseOptions": [
"Approve No Changes",
"Approve With Changes",
"Deny",
"Return to Requestor"
],
"ApprovalCreationInput/title": "Review 'TEST{\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference\",\"Id\":5,\"Value\":\"SalesTracker Target(s)\"}' in SharePoint",
"ApprovalCreationInput/assignedTo": "Suzanne.Noel@xxx.com;;",
"ApprovalCreationInput/details": "- **Modified by:** Dale Simmons <Dale.Simmons@xxx.com>\n- **Modfied time (UTC):** 2022-06-13T14:09:33Z",
"ApprovalCreationInput/itemLink": "https://inteplast.sharepoint.com/contracts/_layouts/15/listform.aspx?PageType=4&ListId=30335dcf%2D68f6%2 ",
"ApprovalCreationInput/itemLinkDescription": "TEST",
"ApprovalCreationInput/requestor": ";;{\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser\",\"Claims\":\"i:0#.f|membership|dale.simmons@xxx.com\",\"DisplayName\":\"Dale Simmons\",\"Email\":\"Dale.Simmons@xxx.com\",\"Picture\":\"https://inteplast.sharepoint.com/contracts/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Dale.Simmons@xxx.com\ ",\"Department\":\"Sales Operations\",\"JobTitle\":\"Manager of Sales Operations\"};",
"ApprovalCreationInput/enableNotifications": true
{
"statusCode": 400,
"headers": {
"Pragma": "no-cache",
"x-ms-request-id": "westus:e5a1fa03-a0de-46af-9772-2a74a88782b0",
"x-ms-correlation-request-id": "e5a1fa03-a0de-46af-9772-2a74a88782b0",
"x-ms-flow-mobile-ios-version": "1.3.0",
"x-ms-flow-routing-request-id": "WESTUS:20220613T150315Z:e5a1fa03-a0de-46af-9772-2a74a88782b0",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "true",
"Cache-Control": "no-cache",
"Date": "Mon, 13 Jun 2022 15:03:15 GMT",
"Content-Length": "372",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"error": {
"code": "GraphLookUpRequestFailedError",
"message": "User lookup request to Graph failed lookup for user identifier: '{\"@odata.type\":\"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser\",\"Claims\":\"i:0#.f|membership|dale.simmons@xxx.com\",\"DisplayName\":\"Dale Simmons\",\"Email\":\"Dale.Simmons@xxx.com\",\"'."
}
}
}
Hi @psargaco
Thank you for posting.
According to your description, you are getting error while configuring approval.
I tried to reproduce your scenario but it works fine from my end. Here is my test process:
SPO list:
Flow overview:
Approval email:
Please help to check whether you select the email part of @odata.
Hope the content above may help you.
Best regards,
Anna
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional