Power Automate Flow Desktop - Ending/Stopping Flow

Like (0) Share

Report

Posted on 25 Jan 2023 01:45:55 by threw001

Hi guys,

I have an Power Automate Online Flow that runs a Power Automate Desktop Flow. I am having an issue with the Power Automate Desktop Flow where the flow never ends. I have tried to add a 'Stop flow' at the end of my Power Automate Desktop Flow however it doesn't seem to be working and the flow just keeps on running

What happens is that the Online Power Automate flow runs and then starts the Desktop Power Automate flow however as the Desktop Power Automate flow never seems to stop/end, the online Power Automate flow still thinks it is running the Desktop Power Automate flow and never successfully completes. I think this is due to the Desktop Power Automate flow not having a stop or the stop not working correctly. Please can you advise?

Desktop Power Automate Mainflow -

Desktop Power Automate Subflow -

Online Power Automate flow to run the Desktop Power Automate Flow -

Thanks so much!

I have the same question (0)

All responses (6)

Answers (0)

momlo 1,527 Super User 2024 Season 1 on 08 Feb 2023 at 07:45:08

Like (0)

Report

Re: Power Automate Flow Desktop - Ending/Stopping Flow

yeah, that's what i mant, if refresh is not completed withing the 45s you will interrupt it by terminating the process, so the data refreshed are not saved, are they so you end up with outdated data?

Reading your initial problem it seems that your excel never completed the refresh hence your "save excel" action was waiting for it forever. So this seems like issue with excel and refresh rather than PAD.

Was this reply helpful? Yes No
threw001 27 on 07 Feb 2023 at 23:15:40

Like (0)

Report

Re: Power Automate Flow Desktop - Ending/Stopping Flow

Hi @momlo - after refresh action I have a wait delay of c.45 secs and then it continues to save and terminate EXCEL processes

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on 07 Feb 2023 at 07:35:47

Like (0)

Report

Re: Power Automate Flow Desktop - Ending/Stopping Flow

Aren't you interrupting the refresh action when you terminate?
Have you considered setting up action to repeat x number of times if it fails? For example: repeat 5 times in 20s intervals

Was this reply helpful? Yes No
threw001 27 on 06 Feb 2023 at 23:44:54

Like (0)

Report

Re: Power Automate Flow Desktop - Ending/Stopping Flow

Hi @Highboy thanks for your help.

I found the issue and it was with Close Excel Instance action, it was still not closing the excel process in the background thus that action never ends. Instead of using Close Excel Instance, i am using terminate process with Excel

Thanks!

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on 26 Jan 2023 at 12:24:20

Like (0)

Report

Re: Power Automate Flow Desktop - Ending/Stopping Flow

You do not need and "Exit subflow" as it always return to the point it was called from.
You do not need to put a "Stop flow" in main, because when it reaches the last line it will stop.
If you cancel the cloud flow, you should be able to see in the log where it was "stuck"

Below is a picture from one of our logs where you can see that it was manually cancelled and what it was doing at the time (Don't mind the Danish text) and that will give you an idea of what your problem is.

Was this reply helpful? Yes No
Kaif_Siddique 2,104 Super User 2024 Season 1 on 25 Jan 2023 at 19:27:59

Like (0)

Report

Re: Power Automate Flow Desktop - Ending/Stopping Flow

1. Debug your PAD flow and see if any issue in flow.
2. What is the PA cloud flow recurrence frequency ?

Was this reply helpful? Yes No