Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Action 'Start_an_approval' failed - GraphLookUpRequestFailedError

(0) ShareShare
ReportReport
Posted on by 3

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:

psargaco_0-1617878960844.png

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.

 

  • dalesimmons Profile Picture
    6 on at
    Re: Action 'Start_an_approval' failed - GraphLookUpRequestFailedError

    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\",\"'."

            }

        }

    }

  • Verified answer
    v-duann-msft Profile Picture
    on at
    Re: Action 'Start_an_approval' failed - GraphLookUpRequestFailedError

    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:

    v-duann-msft_0-1617940131519.png

     

    Flow overview:

    v-duann-msft_1-1617940131523.png

     

    Approval email:

    v-duann-msft_2-1617940131530.png

     

    v-duann-msft_3-1617940131534.png

     

    Please help to check whether you select the email part of @odata.

    v-duann-msft_4-1617940131538.png

     

    Hope the content above may help you.

     

    Best regards,

    Anna

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow