How to auto cancel running flow after some time

(0) Share

Report

Posted on by Community Power Pla...

I have a flow that is pretty simple:

SQL New Item -> Send Email With Options -> Update SQL Based On response

I also have PowerApps Apps where user can do the actions instead of doing them in the email that was sent from flow.

Here are my two questions:

1. Is there a way to kill a running flow automatically after lets say 30 days if it is still running.

2. Do you guys have creative solutions for this problem: where user can take an action via Flow (email options) or within the app (PowerApps). Is there a way to kill the flow immediately when an action is taken in PowerApps to modify the SQL instead of the flow that was running since creation of new line in SQL?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xida-msft on at

Like (3)

Report

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?

For your first question, do you want to kill a running flow automatically after 30 days if it is still running?

If you want to kill a running flow automatically after 30 days if it is still running, I think it is not necessary to add extra actions to achieve your needs, because the running flow would be timed out after 30 days.

There is a limit in Run duration of a single flow run, the max Run duration of a single flow run is 30 days. More details about the Run duration and retention limits of a single flow run, please check the following article:

Run duration and retention limits

If you want to kill a running flow after 7 days (less than 30 days), I think a Delay action and a Terminate action could achieve your needs. I have made a test on my side, please take a try with the following workaround:

More details about creating a Parallel branch action in flow, please check the following blog:

https://flow.microsoft.com/en-us/blog/parallel-actions/

For your second question, do you want to kill your flow immediately when an action is taken within your PowerApps app?

If you want to kill your flow immediately when an action is taken within your PowerApps app, I afraid that there is no way to achieve your needs currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-xida-msft

Thanks for all the info!
It is great to know that running flows are killed after 30 days automatically and thanks for showing me how to do it if I want to kill it before.

As for my second question I will try to figure something out.
I wonder is it possible to call a running flow from another flow, based on some variable (lets say SQL Primary key)?
This way I could use SQL Modify item and it would check if there is any flows running for this particular SQL item and kill other flows.
Maybe I should post this in Idea section 😊

Was this reply helpful? Yes No