cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ww6971
New Member

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
ScottShearer
Super User
Super User

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

gamoraes
Memorable Member
Memorable Member

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
ScottShearer
Super User
Super User

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
gamoraes
Memorable Member
Memorable Member

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!


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

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

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,913)