How to iterate through a data table using python script in PAD?

[NathanAlvares24]

Say I have the following table:

Now what I am trying to achieve is to copy the contents of this data table into another data table. I know this can be done using 'Set variable' action or even 'Insert row into data table' action. But I want to try using python script.

My flow:

So I tried using that script to store the first value of the Name column but I can't seem to access the data table as it doesn't show in the output. Can anyone provide assistance in this? I would be much appreciated.

Thank you,

Nathan

[Agnius]

Can you share a screenshot of the script inside the action itself?

Also, have you enabled the ScriptError variable for debugging to see if it throws an error?

-------------------------------------------------------------------------

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.

[NathanAlvares24]

Hi @Agnius !

Script:

result = ["%MyDataTable[0]['Name']%"]

print(result)

This is just something I was testing out to get the first row of Name column which should result in 'John' but unable to access the data table.

Thank you,

Nathan

[Agnius]

Does it return anything into ScriptError?

[NathanAlvares24]

Hi @Agnius !

Thanks I just checked and made out my mistake.

Now another thing just wanted to ask is that:

Say suppose I want to access the first row of that data table and so on (since I want to iterate through each row of the data table:

But I want the output to store it as a data row. Is it possible? Like in python normally we use libraries like pandas, numpy and all. But sadly, this doesn't work in PAD for some reason. If you could assist me in this, I would be grateful.

Thanks,

Nathan

[NathanAlvares24]

I have used something like this:

name = """%MyDataTable[countName]['Name']%"""
email = """%MyDataTable[countEmail]['Email']%"""

# return this to Power Automate Desktop
print(name, email)

But get this error. I mean there are only two values but not sure of error

[Agnius · Accepted solution]

The output of the Run Python script action will always be a single string in PAD, regardless of what you print. It will always be concatenated into a single string. So, if you want to do it like this, you should use Split text on the output of the script before adding it as a row to a data table.

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