Wait - Process, Service, Window to close?

[GJH]

Hi

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?

[VJR]

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

[garthh]

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

[Jamar_Forsythe]

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

[garthh]

Jamar, thank you 

Perhaps beyond my level at present but will look

[VJR]

@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.

[garthh]

VJY, thank you - I’ll try

[garthh]

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