web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

502 Bad Gateway Error

(0) ShareShare
ReportReport
Posted on by

This flow has been running fine for months, and now every time we try to submit on Sharepoint or the Flow tries to update the Sharepoint, we get the following error. I am not sure which field is causing this.

 

{
"error": {
"code": 502,
"source": "japan-001.azure-apim.net",
"clientRequestId": "5f24909f-19e3-470c-aa7b-a75fe6238ec7",
"message": "BadGateway",
"innerError": {
"status": 500,
"message": "Cannot deserialize the current JSON array (e.g. [1,2,3]) into type 'Microsoft.SharePoint.Connector.SPListExpandedReference' because the type requires a JSON object (e.g. {\"name\":\"value\"}) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON object (e.g. {\"name\":\"value\"}) or change the deserialized type to an array or a type that implements a collection interface (e.g. ICollection, IList) like List<T> that can be deserialized from a JSON array. JsonArrayAttribute can also be added to the type to force it to deserialize from a JSON array.\r\nPath '', line 1, position 1.\r\nclientRequestId: 5f24909f-19e3-470c-aa7b-a75fe6238ec7\r\nserviceRequestId: 5f24909f-19e3-470c-aa7b-a75fe6238ec7"
}
}
Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    From the error I am guessing there is some issue in passing a value to the Update/ Create Item in Sharepoint action in your flow. Can you please share a screenshot of the flow so that we can identify the issue properly and better assist you?

  • Community Power Platform Member Profile Picture
    on at

    Here is the beginning of the Flow

    Term 1.JPG

     

    Term 2.JPG

     

    Term 3.JPG

     

  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    @Anonymous 

     

    Can you also post a screenshot of the error (At which action are you seeing that error)?

     

    Looks like there is some datatype mismatch issue here but it will be easier to find that if you can post the error screenshot along with the action that the flow is breaking at. 

  • Community Power Platform Member Profile Picture
    on at

    The Flow is actually breaking upon even trying to submit an item to Sharepoint.

  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    Yes. Can you post a screenshot of one of those? Can you also share what is the datatype of the columns: 

    Division Date and Division Comments on your SP list? 

     

     

  • Community Power Platform Member Profile Picture
    on at

    Here is what happens when trying to click Save. It is the same error message as my original post.

     

    Division Date = Date & time

    Division Comments = Single line of text

     

    Neither of these columns or any others have changed since we built this.

     

    Term 4.JPG

  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    This looks like an error on your sharepoint form. Are you getting any error on the flow? We need to check which column is generating the error so can you please empty all teh columns and add values and save one by one to check what the issue is and where the error is popping up?

     

    Did your flow run succesfully? Can you check that?

  • Community Power Platform Member Profile Picture
    on at

    I think we are getting somewhere - it finally let me submit after testing every field. However, it looks like the values for Person in Charge (Person or Group Field) and Dealer Divisions (Choice Field) are not being stored. And, this error was produced on the Flow run.Term 6.JPG

     

    Term 5.JPG

     

    Term 7.JPG

  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    Perfect! So when you update the Persons field on sharepoint, do you see any error? By not updating, do you mean that it is not saving when you are making this change manually? In SP when you modify a single column, it will show saved action note on the column itself. Can you confirm this for the Choice type field too? 

     

    Please note that in your flow, you will have to pass these values appropriately (In the choice column you hae to pass the choice value field)

     

    Hope this Helps!

  • Community Power Platform Member Profile Picture
    on at

    I don't see any error for Person or Divisions, but the data is not retained. I tried building a new Flow, and I have the same issue with these fields. It's weird because there are other fields of the same type on the same Sharepoint, but those don't have any issues, just those two.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard