Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Approval Flow BadGateway Error

(0) ShareShare
ReportReport
Posted on by 9

Greetings,

 

I've been using my AP Approval Workflow for a couple of weeks with no issues, however, I made a few changes to one of the SharePoint list that the flow is attached to and then I started to get the BadGateway Error.

 

Here's my original flow:

 

RaulAG_0-1622660537136.png

RaulAG_1-1622660557031.png

 

RaulAG_2-1622660566460.png

RaulAG_3-1622660575213.png

 

RaulAG_4-1622660590740.png

RaulAG_5-1622660600181.png

 

RaulAG_6-1622660630191.png

 

RaulAG_7-1622660648128.png

 

RaulAG_8-1622660659349.png

 

I have a SharePoint list called Departments and here is where I made some changes, specifically in the Approvers Text Columm, I changed email addresses:

 

RaulAG_9-1622661077670.png

 

Here are my flow run fail details:

 

RaulAG_10-1622661255164.png

 

RaulAG_11-1622661264718.png

 

Here's the error code:

 

{

  "error": {

    "code": 502,

    "source": "canada-001.azure-apim.net",

    "clientRequestId": "bc66974c-56f2-483f-a8bc-7776c4dddd51",

    "message": "BadGateway",

    "innerError": {

      "status": 500,

      "message": "Cannot deserialize the current JSON object (e.g. {\"name\":\"value\"}) into type 'System.Collections.Generic.IEnumerable`1[Microsoft.SharePoint.Connector.SPListExpandedReference]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.\r\nPath 'Value', line 2, position 11.\r\nclientRequestId: bc66974c-56f2-483f-a8bc-7776c4dddd51\r\nserviceRequestId: bc66974c-56f2-483f-a8bc-7776c4dddd51"

    }

  }

}

 

RaulAG_12-1622661379068.png

 

Any help would be greatly appreciated.

 

 

 

  • Community Power Platform Member Profile Picture
    on at
    Re: Approval Flow BadGateway Error

    Hi

    Here this the solution!

    https://www.heiigjen.com/PA-ApprovalFlow-BadGateway

     

    Thanks  Trond Aarskog !! 🤜🤛

  • Verified answer
    Kcronic1 Profile Picture
    on at
    Re: Approval Flow BadGateway Error

    Hello @RaulAG,

     

    In reviewing your post there seems to be an issue with the value that you are updating in the SharePoint List. It seems the action item you are referencing appears to have some property type issues.

     

     Have you tried deleting the Approve Updated item action and recreating it since you’ve updated the list?

     

    If not, I would recommend deleting the action and recreating it. It’s looking for an array of items but is only returning a single item not affixed in a type array.

     

    Hope this helps 😊

     

    Regards,

    Kristie

    Community Support Team

     

    If this post helps, then please click on the "Accept it as the solution" to help the other members find it more quickly.

     

    If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: Get Help + Support - Power Platform | Microsoft Docs

     

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,635 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow