cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Flows stop triggering unexpectedly Bad gateway 502?

Hi, I've had a number of flows stop working all of a sudden with little information on what is at fault. The flows have been working fine and were not modified aroudn the time they stopped working. The only nugget to go off is the error 'bad gateweay 502' which is reported in a some of the recent failed runs.

 

I'm unable to trigger the flow (sharepoint new item is created or modified) so i'm stumped as to why it is not triggering. I've created a simple flow in the same account with the same trigger, that works the first time then doesnt work any more...

 

I've tried copying the flow to another account but that doesnt work more than once either!

 

I've tried copying the flow and deleting the original (because i was concerned there were quite a few instances of the flow running) but that didnt work either.

 

Really at a loss as to what is wrong and this is having a significant impact on our operations. if anyone has any pointers or guidance i'd appreciate hearing them.

 

The actions contained in the flow are:

Sharepoint update item

Sharepoint get items

Outlook send email

Outlook send email with options

 

Thanks,

Eddie

83 REPLIES 83

Have you tried support? Their mandate covers fixing broken objects, however, to be fair it'll take you several attempts to get your issue across to them. You'll need to reiterate the issue several times just to be sure. Then you'll get links on how to create a flow. 🙄🤔

Then you can try Microsoft Answers. You usually get a good answer there. This forum doesn't seem to not be worthwhile any longer. There's a few responses but typically, now it's just a bunch of supposed know-it-alls viewing your question then going on to something that's not "so below them" or where they can get cudos links easy.

One thing you might want to try is rebuild the flow from scratch just to be sure. Also check your data connections.

RayConsella
Advocate I
Advocate I

I have found more than two dozen different threads here, all regarding this same topic with hundreds of unresolved complaints. I have personally logged 23 support tickets for this although none in the last year since not a single one could tell me why it was happening much less fix it. Mind you, in my case it's a failure to communicate with Azure SQL.  Not oracle or Mongo or even some small-fry cloud product.  AZURE.  Their own product!  Seriously?? I love your "Have you tried MS Answers" optimism though. I had that optimism too, like 672 flow failures ago. The fact that this isn't even acknowledged as an issue, given the fact there is no roadmap to fix and not one of the 23 support techs I worked claimed to have heard of this before (aka, it's only happening to me so it's somehow my fault or I didn't set up the flow right) is beyond insulting, it's  a middle finger to the Flow community.  Microsoft - if you can't get Flow, I mean NoPower RarelyAutomated, to communicate with your own cloud DB product....um WTAF are you doing?

TrellisRuss
Frequent Visitor

Ok, so this is what I did:

  1. Make a copy of the Flow
  2. Delete old Flow
  3. Start over with new Flow
  4. Ctrl + Alt + Del
  5. Fixed!

😄

MartinaHawkins
Advocate I
Advocate I

Ended up rebuilding the Flow which had a lot of steps and it is working now but for how long I don't know.  Have no confidence in it

What do you mean by Ctrl + Alt + Del?

In reference to, if something is wrong with your MS product, just reboot! 😄

Excellent. I figured that'd be the case. 
To me it sometimes behaves like MS Access where there are ghost objects hanging around and you need to compress and clean it out. 

One would think, no EXPECT that in today's day and age in 2022 this type of thing would be in the past but alas, here we are STILL.
I'm not surprised people get attacked and blamed for doing things wrong and breaking things although its web based off their systems ??????????????????? 
That's unprofessional and very politician like, heaven forbid they take responsibility for their actions. THEN, you, well I have, had the "know-it-alls" come in and instead of helping when you had the original issue and opted to view and move on, they act like you've hurt their feelings by talking smack about the tech.
Are you surprised by any of this? 

At least you got it fixed, without their help!!! Kudos.

My sentiments EXACTLY!

stamperadam
New Member

I resolved this issue by duplicating my flow and scrapping the old one. Exact same, simple, flow and it has worked ever since. However, I have resorted to using Flows less and less in my workflows because I really don't feel I can fully trust it. That's unfortunate because I initially had hopes of using it more.

This only happened to me once 3 years ago and it was to do with getting rows from an excel file action. Duplicating the flow back then didn't fix it for me. Duplicating the excel file didn't work either. I literally had to rebuild the excel template file from scratch with about 100 columns... it worked fine ever since. 

Regardless of what the ""experts"" say, there are issues. People get blamed for breaking their flows etc. but how can you break something that isn't local but stored in their systems?

Their tech, their issue. 

I've mentioned elsewhere the emperor sometimes doesn't have any clothes on.

 I get things break and things aren't completed but TAKE OWNERSHIP!!!!!!!!!! Finish and fix the tech you have now, stop creating new useless tech prior to ensuring what's already prematurely released is fixed/finished.

Right, which leads people to ask: WHY????!!!! 

Whats broken and where.

The hope is you do what you did and they don't have to concentrate on fixing it but rather closing the case file as complete and therefore padding their numbers even though they did SQUAT.

This template generates Payroll Report every month for our staff so I couldn't wait for them to fix this. They never did in fact. Like I said, my ticket vanished.

I haven't had many issues but my recent one is to do with the On-Premises Gateway. When I set it up originally 3 years ago, the region was set to UK South. Now that Gateway is no longer available in Power Automate connections, can't be modified but it bloody works!!! They said that the region I have in the Gateway agent is wrong and does not match my tenant's region, Europe. I know the UK left the EU, but as far as I know, the UK is still in Europe.

A few emails later, and not because they told me, it turns out that I had to set the Gateway to West Europe in order for me to see it on the PA connections page, BUT Power BI can't see it! WTF? So now I need to use two Gateway instances on two different servers, one for Power BI and one or PA............ oh and every time you need to change th region in the Gateway you have to uninstall it lol

zenzen
New Member

I have similar problem when i convert html file to pdf. Its worked well, until today. I have several flow with this error

 
Error
Action 'Convert_file' failed

 

error": {
"code": 502,
"source": "flow-apim-europe-002-northeurope-01.azure-apim.net",
"clientRequestId": "725b69a7-ccc6-4f6c-b91a-e51e7f6107fb",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Service Unavailable ...

"source": "api.connectorp.svc.ms"
}

Ste_
Regular Visitor

Hello! All my flows failed today at the same time... I'm getting this error on action "Run a flow built with Power Automate for desktop":

 

{
  "error": {
    "code"502,
    "source""flow-apim-msmanaged-na-centralus-01.azure-apim.net",
    "clientRequestId""3a10e4f2-d687-43d7-a218-589e95de1220",
    "message""BadGateway",
    "innerError": {
      "error": {
        "code""InternalServerError",
        "message""Http request failed with unhandled exception of type 'NullReferenceException' and message: 'Object reference not set to an instance of an object.'."
      }
    }
  }
}
CW
Advocate V
Advocate V

Yes isn't that special? What a wonderfully intuitive error message. 

Maybe try removing and re-adding your connections to that flow.

Remove connections, leave Power Automate altogether, reopen PA, re-add the connections leave again reopen and try a test.

That's all I can think of sorry. Hope it comes back up for you!

Ste_
Regular Visitor

Thank you for trying to help me!
I removed one connection, but now I can't seem re-add it... I checked the Machines page and got this error "There's an issue loading your gateways. Please try again later."
Guess I have to wait...

CW
Advocate V
Advocate V

Hmmm. I've had that too but can't recall what I did. What I did discover was I had multiple connections to the same gateway. Seems you can just accidentally, willy-nilly add the same connection over and over and over again.

I removed ALL connections then reconnected by manually running flows and choosing the ONE connection when prompted.

Ste_
Regular Visitor

Unfortunately, what I had to do was move my flows to a new environment. All the flows worked fine after this. But I still don't know what was the cause of the bad gateway error 😞

TrellisRuss
Frequent Visitor

No one knows why, it just happens and MS doesn't really give a sh#t! I have unfortunately just stopped using it because it is so unreliable.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,048)