Run python scripts in Power Automate

user_10302054 0
Viewed 10221

I use Power Automate to fetch some data from SQL database and save them into different excel files. After my workflow is done, I have 8 different excel file, and I need to do some data preprocessing on them. I've got the python script which consists of various libraries such as pandas etc. and does the job but I need to make it automate.

What I want is basically after my workflow is done, running the python script automatically with Power Automate.

I read some articles about it such as article1. Is there any other way except using the azure functions? Because it seems a bit complex and it's only free for 12 months.

power-automate azure-functions python
1 Answers

As far as I know, we can just use azure function to run python script in power automate. I think the best solution is use azure function which you are using now.

For you concern about cost, you can create the function with a free app service plan (if your requirements do not need high performance）. You can refer to this document about app service plan.

enter image description here

Even though you don't choose free app service plan, it will not cost much more if you choose consumption plan for your function.

user_110992130
Related