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

86 REPLIES 86

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.

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?

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!

😄

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!

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
Regular Visitor

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.'."
      }
    }
  }
}

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!

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...

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 😞

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

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Top Solution Authors
Users online (4,626)