SharePoint Flow Bad gateway and error status code 500 or 502

Question

I'm developing flows for our SharePoint site. The particular flow looks like the following image. A form is submitted, an existing item called and a variable incremented based on the "get item". A new item is then generated with user information from the form, an existing item updated and email sent to the appropriate person for action.

Until 1 day ago this Flow was operating as intended. I made some changes to the form by adding more questions, then added the same details to columns on a SharePoint list to accommodate the new answers. Then I modified the Flow to handle this information appropriately.

I only added 3 new pieces of information, all of which were text and I've reviewed the data types to ensure that I've not inadvertently set a data type to numerical or an integer or something silly.

The Flow will no longer run and it fails at the "create item" stage above - which is the list item receiving much of the data from the user form. 

Details are shown below - indicating a bad gateway and error code of 502. However some instances throw an error of 500. The error does not appear to be consistent.

In trying to remedy the issue I've;

• Modified data types throughout the form and list entries
• Tried not inputting any data into some fields in the form in case there was a data type mismatch
• Removed the new form questions, List columns and subsequently the new items added to the Flow
• Restarted my machine
• Cleared cache in Google Chrome (after reading other possible troubleshooting relating to cache and error 500/502)

None of these actions have provided any resolution, irrespective of changing back to the original configuration (which was working only 2 days ago).

Can i get more information on what is likely to cause a bad gateway, error 500 or error 502?

Thanks

[PII is masked by Nathan Li MSFT Support]

Answer 1

Hi Nick,

As your concern is about running your codes on Microsoft Flow, to ensure you will have the best support experience, we suggest that you may post your question and screenshots in the Microsoft Flow Community to get dedicated assistance from our Microsoft Flow support engineers.

Best Regards,

Nathan

Answer 2

Hi Nick,

Please don't worry. I also notice that some threads in that forum remain unresolved for some time, and that seems because the engineer was requiring more details of their Flow, such as screenshot of the Flow and their codes, and the user didn't post back any longer. With these information provided, the Microsoft engineers should be able to investigate the error carefully and find a solution for you.

Best Regards,

Nathan

Answer 3

Thanks. I've posted there now. It was a bit concerning that similar issues have gone unanswered on that forum for over 6 months though.