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

(0) Share

Report

Posted on by NathanAlvares24

1,714 Moderator

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Does it return anything into ScriptError?

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No