cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ww6971
Level: Power Up

Stop flow re-triggering on item created/modified

Hi! Need assistance modifying a flow to only trigger once. I have a flow set up to send an email when a box that defaults to no is set to yes. However, it keeps running each time the item is modified and we only need it to send the initial email. Any ideas to help?

 

SS.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Stop flow re-triggering on item created/modified

The suggestion has been made in Flow Ideas to change this behavior, but it hasn't happened yet.

 

As a work around, you may want to have a second hidden column (Flag) that gets set when the email is sent.  If the Flag is set to a specific value, then don't send the email and exit the Flow - put this logic at the top of your Flow.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Super User
Super User

Re: Stop flow re-triggering on item created/modified

Hi @ww6971

 

First of all, welcome to community.

 

As @ScottShearer said we have only this workaround for a while, but it works.

 

After create a new column in your SP list to flag 'Mail sent', in your flow after send the e-mail you can update the current item column 'Mail Sent' to true, create a condition to verify if 'Mail sent' is true, if yes use a Terminate Action as Canceled to differentiate between successful and error.

 

Best Regards,

 

Gustavo Moraes


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

4 REPLIES 4
Super User
Super User

Re: Stop flow re-triggering on item created/modified

The suggestion has been made in Flow Ideas to change this behavior, but it hasn't happened yet.

 

As a work around, you may want to have a second hidden column (Flag) that gets set when the email is sent.  If the Flag is set to a specific value, then don't send the email and exit the Flow - put this logic at the top of your Flow.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Super User
Super User

Re: Stop flow re-triggering on item created/modified

Hi @ww6971

 

First of all, welcome to community.

 

As @ScottShearer said we have only this workaround for a while, but it works.

 

After create a new column in your SP list to flag 'Mail sent', in your flow after send the e-mail you can update the current item column 'Mail Sent' to true, create a condition to verify if 'Mail sent' is true, if yes use a Terminate Action as Canceled to differentiate between successful and error.

 

Best Regards,

 

Gustavo Moraes


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

Sbonerabon
Level: Power Up

Re: Stop flow re-triggering on item created/modified

Has this been updated yet or would this workaround still be required. I have flow keep triggering still
Super User
Super User

Re: Stop flow re-triggering on item created/modified

@Sbonerabon I don't know if this is a work around, but if the email is to be sent only once on any event other than when it is created, setting a flag is the best option.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,671)