Unanswered

Custom variable index within a Python / VBA / Javascript script

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

is there a possibility to pass a variable as property for a power automate variable, like datatable? so selecting a value passing a dynamic index to datatable, something like that:

%Variable_Datatable[custom_index][custom_index]%

I've tried with making custom_index as environment variable, but I cannot set it inside the script, in the loop... so it remains static....

example I want to achieve:

for i in range(0,5):
 %Variable_Datatable[i][i]%

Thanks!!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (0)

Community Power Pla... on at

Like (1)

Report

Hi @Anonymous ,

You should be able to pass JSON object to PAD.
In your JSON object you can pass multidimensional array
And use "Convert JSON to custom object" action to use the object values.

Hope this helps 🙂

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

Like (0)

Report

Hi @Anonymous, ok thanks (i see the other reply) but inside a Script (like in python)? it is not possible to retrieve a dynamic value with the custom object?

Was this reply helpful? Yes No
burque505 398 on at

Like (0)

Report

@Anonymous, at least with the Python 2 inside PAD it is possible.
Script blowup:

I will see if I can get Python 3 to cooperate, that would be better for me.
Regards,
burque505

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

Like (0)

Report

Hi @burque505 ,

thanks but I was meaning retreving a value passing custom index, so in this way:

%Variable_Datatable[i][i]%

Thanks

Was this reply helpful? Yes No
burque505 398 on at

Like (1)

Report
Let me give that a try. Will report back. I have the suspicion the indexer may also need to be a variable, something like:
for %i% in range(0,5): %Variable_Datatable[%i%][%i%]%

but I admit this doesn't look right. I don't have anymore time this morning to experiment, but I'm certainly looking forward to seeing someone solve this for you.

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

Like (0)

Report

Why don't you loop through the data table within PAD and execute the script per step or handover the full data table to the script and use the script's functionality to access the individual cells?

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

Like (0)

Report

Hi @fraenK ,
because of the time... the loops connector are too slow and also to take advantage of scripting power.
I don't understand this part
handover the full data table to the script and use the script's functionality to access the individual cells
what do you mean?
Thanks
@fraenK

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

Like (1)

Report
You declare a variable at the beginning of the (Python) script and set its content to the content of your PAD data table variable:
pyDT = %Variable_Datatable%
Then loop through the pyDT with the package of your choice.

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

Like (1)

Report

The following statement is missing from the UI, that's why your initial idea doesn't work:
Within the script, you may include variables, since they will be evaluated prior to the code's execution.

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

Like (0)

Report

hi @fraenK
it doesn't work because the data table have its values separated with commas, and also without the double quote on string character. this generate an issue when passing it as variable

Was this reply helpful? Yes No