Unanswered

Power Automate Desktop

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,
I am using Power Automate Desktop (installed from MS Store). I have to automate an ETL pipeline written in Python and SQL. It's little complex and time-consuming script (might take 20-30 mins to execute completely). Just wanted know if this can be done using PAD.
I have tried this using PAD PowerShell scripting function, but I am not getting the desired results, flow is working fine without any errors, but it seems the code is not running at all whereas small scripts are working well and good. Can I have some suggestions on this, please?

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to run Python code, there is a Run Python script action in PAD that supports Python 2. If you need any functionality that is available in later versions of Python, that won't work.
SQL scripts are also available via the Execute SQL statement action in PAD.
Other than that, I'm not quite sure what it is that you want - do you want to keep the Python script and simply launch it automatically via PAD, or instead do you want to replace it with a PAD flow? If you want to replace it, you will need to provide more details as to what the script is supposed to do in order for the community to be able to help you.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Agnius,
Thank you for your response. I have the script written separately as (for e.g., pipeline.py). I just want to launch it with the PAD. I cannot use Run Python Script action as it does not support version 3 and above.

Thanks & Regards,
Ankit
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You could simply use Run application to run the script. But it will obviously not return any outputs if the Python script returns anything.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.