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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard