web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL when a item is cre...
Power Automate
Unanswered

SQL when a item is created never stops

(0) ShareShare
ReportReport
Posted on by 2

Hi all, 

 

after deep looking into the internet to find a solution to my problem, I finally give up and post here. I hope someone can help me.

 

I try to build a simple flow that sends an email when an item is created. And that works perfectly fine! Or I should say, it works toooooooo fine. Lol. In fact, the flow never stops running and sends thousands of emails. And it won't stop till I turn off the flow. 

 

Any idea why?

 

More optional information:

  • I had to create an identity column that didn't existed before, as it is a mandatory point regarding documentation
  • I'm using a gateway to connect Power Automate to my company server. I'm using a connection showing that the status is "connected"
  • Yesterday, I build the flow and it worked just fine (1 email sent) when I've added an item in the SQL table
  • Today I wanted to see if it still worked. I created a new item in the table and the flow began to go crazy. I received hundreds of the same email.
  • While I was trying to debug, I created 3 more items in the SQL table. Now I receive hundreds of mail times 3!! One for each new entry, looping infinitely till I turn off the flow
  • Here the flow: 

Latouate_0-1640877438339.png

  • And here the infinite history. As you can see, it triggers 5 or 6 times per minute

Latouate_1-1640877527731.png

 

 

 

Thanks in advance for your help.

 

Happy new year's eve!!

Categories:
I have the same question (0)
  • Latouate Profile Picture
    2 on at

    UP, if someone can help. 

     

    Rgds

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 550

#2
Valantis Profile Picture

Valantis 390

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard