How to use Python list value in 'Run Python Script'?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello.

I have a question to using Power Automate Desktop.

I find flow called 'Run Python Script'

So, I tried to use this. but one problem (maybe..?one?)

PAD's value in List is not defined to python script.

How to use this 'List value'?

I think my python grammar is OK.

Sorry to my English

cause, PAD Tool got 'Run Python Script' Flow....

plz help me 😞

Here is the my problem

Traceback (most recent call last):
File "<string>", line 5, in <module>
NameError: name 'test0' is not defined

My List1 =

my python script

Power Automate free license limitations

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

ZS440 262 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
hi
This may help you.
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/About-Run-Python-Script-action/m-p/808382/highlight/true#M1211

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

%List1[cnt]% returns the string test0, so you're missing the quotation marks around %List1[cnt]% in line 5

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I faced the same problem, when you pass a variable into a python list from PAD list or datatable it comes without " double quotes ... so you have to add them manually before appending the value to the list

--> See my post below <--

Was this reply helpful? Yes No
fraenK 2,125 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, but this "issue" here is totally different than yours 😉

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I modified my reply... but this is also related to my issue
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Custom-variable-index-within-a-Python-VBA-Javascript-script/m-p/862418#M2126
Because the list and datatables comes with plain text without double quotes on string... so assignign the list or datatable to a python variable (like you reply on my post) it is not working!! for the same concept of this question

I was meaning that! Thanks

@fraenK

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

I got the solution 🙂 you have to transform your list before in text, by adding the " double quotes... so doing this way:

You have your LIST1:
Before executing the python script, you have to create a text variable structured as python list. So in this way:
The ouput would be this:

test0","test1","test2","test3","test4","test5

Now you have the python script, but you have to add the square brackets before and after the list, to have this

["test0","test1","test2","test3","test4","test5"]

So the python code is

List1_new = %'[\"' + JoinedText + '\"]'% testa = %cnt% testb = [] cntt = 0 for k in range(3): testb.append(List1_new[%cnt%]) cnt+=1 ...... ......

Let me know if it works 😉

PS. If you have numbers on list, you have to find a way to cast them before to use them in python

Was this reply helpful? Yes No