Unanswered

Wait - Process, Service, Window to close?

(0) Share

Report

Posted on by GJH

I run a Python script by the Action 'Run Application' and the script produces an excel file. The excel file can take seconds or minutes to complete depending on the amount of data the script has to compare. The time it takes for the sript to run changes daily.

The Flow would be more elegant if it continued immediately after the script finished/excel file was complete rather than using a Wait Action based on the longest period the script look to finish. I have tried Wait for Process to stop, Wait for service to stop and Wait for window to close but none appear to work. Perhaps I'm using a incorrect title, handle or UI element

Can anyone help?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you saying even the "Wait for file" is not working as expected?

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

VJR, the script opens the spreadsheet and continues to write to it so the Wait for file doesn’t wait for the script to complete as the file is there. The need is to stop the Flow moving to the next step. At present the file/spreadsheet only has some of the data because the Flow has moved to the next Action. When running the script outside the Flow all works properly

Garth

Was this reply helpful? Yes No
Jamar_Forsythe Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

PAD has actions to run Python, have you tried that?
You can read the script from a get file details and use that variable or you can paste the code directly into PAD Python action.
Scripting - Power Automate | Microsoft Learn

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Jamar, thank you
Perhaps beyond my level at present but will look

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

@garthh

Here is one option..

Have the script write some comment to a text file after the script is completed....something like

<PROCESS COMPLETED>. You might also want to add the datetimestamp depending on the frequency of you process.

Then after "Run Application" have PAD actions to check whether this text is present or not in that file. This should be in a loop checking after every few seconds (eg; 30).

At the beginning have the script write <PROCESS STARTED> so that the next time will be taken care of.

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(1)

Report
Copy link

Link copied!

VJY, thank you - I’ll try

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

VJR, the script was written by the developers so I prefer not to edit it. The script opens a window when it’s running and I tried the ‘Wait for window to close’ again and it appears to work. More testing with different size files needed to confirm. Thanks again

Was this reply helpful? Yes No