Unanswered

How to pass a flow variable of data table type from Power Automate to a Python script?

Like (0) Share

Report

Posted on 8 Feb 2023 02:44:47 by Shahabas

I want to perform some complex operations on an Excel document, and I am not very familiar with Power Automate, but I can write a python script to handle the Excel file. Therefore, I want to embed my python script into Power Automate, which makes it easier for me to debug my python script in real time and also makes it convenient for my colleagues who are not familiar with programming to carry out the work through the work flow I shared.

I started an Excel file from a local folder through Power Automate and outputted a flow variable called "ExcelInstance". I then read the values of all cells in the worksheet and stored them in a flow variable called "ExcelData". Now, I want to continue with the next step by adding an action to run a python script. However, I am having trouble passing the flow variable "ExcelData" to the python script so that "ExcelData" can be converted into a DataFrame in python.

Could you please tell me how I can pass "ExcelData" to Python through code? Thank you very much for your help!

All responses (5)

Answers (0)

Agnius Bartninkas 10,045 Most Valuable Professional on 24 Oct 2023 at 06:29:15

Like (0)

Report

Re: How to pass a flow variable of data table type from Power Automate to a Python script?

Python 2.0 does have imports. It's just that the syntax is different and not all libraries are supported. @Joe007 , officially, Pandas support Python 2.7 and some of the Python 3.x versions, so 2.0 may not be supported. But you can try following the instructions here on how to install it and try it out yourself: https://pandas.pydata.org/pandas-docs/version/0.23/install.html

-------------------------------------------------------------------------
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.
Pavel_NaNoi 1,072 on 23 Oct 2023 at 14:09:36

Like (0)

Report

Re: How to pass a flow variable of data table type from Power Automate to a Python script?

Can't, PAD uses python 2.0, which if I remember correctly, didn't have imports.
Joe007 2 on 21 Oct 2023 at 13:50:24

Like (0)

Report

Re: How to pass a flow variable of data table type from Power Automate to a Python script?

It worked however it is of string type.
How we can import pandas within python script?
Shahabas 3 on 09 Feb 2023 at 06:26:25

Like (0)

Report
Re: How to pass a flow variable of data table type from Power Automate to a Python script?

Hi @momlo,

Thank you for your reply.
I tried the method you mentioned, but it didn't work.
I find that in this method, the author has passed an Input/Output variable into python, and the variable content is a string. In the problem I encountered, the variable is Flow variable, and the content of the variable is a Datatable. I saw someone say that you can put a $ sign in front of the variable to indicate that it is a Datatable, like this:
DataTable = """$%ExcelData%"""
But it still doesn't work:(

If you have any ideas, please feel free to let me know. Many Thanks!
momlo 1,527 Super User 2024 Season 1 on 08 Feb 2023 at 09:06:14

Like (1)

Report
Re: How to pass a flow variable of data table type from Power Automate to a Python script?

Hi @Shahabas
Declare python variable and set to the PAD variable:
song_list = """%SongList%"""

Taken from here:
https://www.wiseowl.co.uk/blog/s2986/power-automate-desktop-python-script.htm