cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

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

Highlighted
Memorable Member
Memorable Member

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
Highlighted
Super User III
Super User III

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

Highlighted
Memorable Member
Memorable Member

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

Highlighted
Regular Visitor

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
Highlighted
Super User III
Super User III

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,531)