Can you set an automated flow to stop processing after 10 minutes

[skillsy]

Hi, 

   I have a flow that reads through an online Sharepoint Excel Spreadsheet looking for new entries and have filtered the List Rows present in a table to return about 60 rows that are active.

   Twice now a flow just keeps running (14 hours this time) and subsequent flows also just start running and never finish although the odd one finishes correctly. The process should run every 15 minutes so if after 10 minutes, I would like the flow to die no matter where it is up to and email us that it has failed. Is this something that can be done easily?

  Secondly DAK why this might occur. We do have three or four editors in the sheet at anytime but this was around midnight.

Thanks

[Mira_Ghaly · Accepted solution]

@skillsy 

Try the below solution at the beginning of your flow after the recurrence trigger add a parallel branch with the desired delay, Send Email and call the Terminate Action this will stops the execution of your flow.

You can change the Message and code of the Terminate Action below:

Hope this makes sense!

[skillsy]

Thank you @Mira_Ghaly  for the exceedingly well explained process however will this not fail every time at 10 minutes even if the work branch was successful?

[dennisb88]

To fix that, you should add a terminate action also below the apply to each actions. The you need to set the terminate action to succeeded.

[skillsy]

Thanks @dennisb88 and through this thread and others who know far more than me, I managed to get it working so well, I have deployed this to other key flows...

The toolkit

1. Create a boolean  variable of processingCompleted and set it to false
2. Create a branch just below this and...
3. Do all your funky Flow stuff and at the very end, set processingCompleted = true
4. The other branch, put a delay in and then check the value of processingCompleted and if it is false then you can create your warning and terminate.

I hope this helps