Answered

Sharepoint Update Bad Gateway

(0) Share

Report

Posted on by NWEASD

174

Recently my flow that has been working without problems stopped. The only error that I am seeing is it saying bad gateway. The same flow has no problems getting triggered (When an item is created/modified), getting the metadata, or getting the information changed in the item. The only problem it is running into is when the the automate process goes to update the item with any changes that were made.

Any thoughts on this?

I tried giving it time thinking that this problem would go away but it has been this way now for 3 days. We rely heavily on this working properly. Any help would be appreciated.

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@NWEASD Are you getting error in the Update Item action? If yes, could you share the screenshot of the update item action? Also are there any changes made of list/columns what may have affected the flow?

Was this reply helpful? Yes No
NWEASD 174 on at

Like
a
(0)

Report
Copy link

Link copied!

I just get the error on the Update Item action. There was some changes to the item's columns, but since then I have completely removed the update action and re added it from scratch. I did not recreate the entire flow as it is massive.

Hopefully these images help you more than they help me.

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@NWEASD badgateway error occurs when we try to push invalid data into a SharePoint list item, Can you make sure the values provided in update item are valid values, and also does it show any further details in error other than BadGateway. there could be status and message in error details which will point to the details of error from which we can know which column value could be creating the error.

Was this reply helpful? Yes No
NWEASD 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately I am not getting any more information than bad gateway. Even when watching the flow run I get the same thing. The only columns that changed went from a lookup column to a choice column. I have 3 choices to make when I want to update those columns. They are (Name of Column), (Name of Column) ID, and (Name of Column) Value. When I select the Value one it puts it into a apply each. I really am not ready to update the event that many times based on the fact the trigger is created or modified. I have it currently with just Name of Column. I will switch it to Name of Column ID and see if that helps. I will also remove it and see what happens.

Was this reply helpful? Yes No
NWEASD 174 on at

Like
a
(0)

Report
Copy link

Link copied!

To update. Thank you for the more info on the bad gateway. I was able to find one error it was having. Using a value instead of passing it the field itself. Now my error is still Bad Gateway. Status is 500. Message
"Cannot deserialize the current JSON object (e.g. {\"name\":\"value\"}) into type 'System.Int64' because the type requires a JSON primitive value (e.g. string, number, boolean, null) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON primitive value (e.g. string, number, boolean, null) 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 'Id.['@odata.type']', line 3, position 19.\r\nclientRequestId: 01004138-cedd-4ab3-ae4c-5ef8dc4c141a\r\nserviceRequestId: 01004138-cedd-4ab3-ae4c-5ef8dc4c141a"

Here is the body of the update
{
  "Title": "Title",
  "EventDate": "2021-01-16T12:15:00Z",
  "EndDate": "2021-01-17T00:15:00Z",
  "Name_x0020_of_x0020_Group": "Group",
  "Specific_x0020_Purpose_x0020_of_": "Reason",
  "Name": "Name",
  "Email_x0020_Address": "email",
  "Phone_x0020_Number": "Phone",
  "Inside_x0020_Location": [
    {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      "Id": 29,
      "Value": "None"
    }
  ],
  "Outside_x0020_Location0": [
    {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      "Id": 20,
      "Value": "Location"
    }
  ],
  "Building": {
    "Id": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      "Id": 7,
      "Value": "Building"
    }
  },
  "Access_x0020_Time": "2021-01-16T12:15:00Z",
  "Location": "Location String",
  "Approved": false,
  "Pre_x002d_approved": false
}

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@NWEASD , which column did you change from lookup to choice? Still the error you are getting, is related to the value provided for column is invalid for its type.

Was this reply helpful? Yes No
NWEASD 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help. The building column is requesting the ID and I was passing it the building json. I switched that to building ID and it is working. Lessoned learned. Read the columns that are being requested carefully.

Was this reply helpful? Yes No