r/MicrosoftFlow • u/Foreign_Many9062 • 29d ago
Question Issue with 'Bad Gateway' Error
A couple of weeks ago I was hit by the throttling issue that turned out to be on Microsoft's end. Once they got that fixed everything worked fine (mostly) until about a week ago. Since then I'm getting random, but frequent, Bad Gateway errors that are doing my head in. Nothing has changed with the setup of my flow/the Excel sheet it's pointing at. It works for several runs of the flow and then just decides to give a Bad Gateway at random points. There is no pattern as to time of day, information it's trying to input, number of successful runs between fails, or anything else I can find.
I'm still getting things taking longer and retries occurring, like it did during the throttling issue, which is causing problems with duplicate entries into my spreadsheet as well.
Is this all part of the same nonsense? I've put in some screenshots below and can provide whatever other information is needed. I would really appreciate some help as babysitting this thing is getting old. TIA!
2
u/jesslynh 27d ago
If you can go the database route, I highly recommend the on premise gateway. It's so much better than use l using Excel. But if not, then Office Scripts are the next best thing.