how can I use a variable as a index of a data Table?

(0) Share

Report

Posted on by vleitao

Hello everyone,

need your help, I need so use a variable inside another variable.

For example I have a ExcelData and if I want second row first columm I will do %ExcelData[2][1]%

What I want is %ExcelData[%LoopIndex%][1]%

But I have a syntax error, how can I use a variable as a index of a data Table?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (0)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Remove the % signs from the inner variable(s). Try this: %ExcelData[LoopIndex][1]%

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

ryule is right.

For future reference and more details here

What you need to know is in this section of the documentation.

Was this reply helpful? Yes No
ammadak11 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I have figured it out...

Suppose if your Variable value is in the form of Text and not in Integer/number then you can use the option "Convert text into number"

If you then use your variable in lets suppose %CSVTable[varRow][varColumn]%

Hope it will help you.

Was this reply helpful? Yes No
MateusCorrea 9 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried your sugestion and removed the % signs from varRow, but didn't worked
%Legend[varRow]['type']%

Tha value of varRow is 16, and PA found this error: The variable Legend does not have a property '16'.

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

Like
a
(0)

Report
Copy link

Link copied!

Is the value of varRow a numeric value, or have you set it with quotes? Also, is %Legend% a data table?

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

Like
a
(0)

Report
Copy link

Link copied!

I have the exact same problem and it's strange. I'm questioning whether it's a bug in the somewhat recent version of PAD I'm using. I also tried converting the variable to a number and to text as part of my testing, neither worked... A clear case of variableName = 0 and using variableName doesn't work but 0 does.

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

Like
a
(2)

Report
Copy link

Link copied!

If the variable is of type text, it won't work. For example, if you use Find or replace in data table, the output indexes in %DataTableMatches% are strings (no idea why, though) and must first be converted to numbers before they can actually be used to retrieve a value from the table.

Was this reply helpful? Yes No
ammadak11 9 on at

Like
a
(2)

Report
Copy link

Link copied!

check the data type from your loop. if it is a text output it will not work. To get the value from DataTable fron Index reference, input should have to be integer.

Was this reply helpful? Yes No
MateusCorrea 9 on at

Like
a
(0)

Report
Copy link

Link copied!

This is exactly what I did, I used Find or replace in data table to get a row that I need... Now Im trying to use that data.
How can I convert to numbers?

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

Like
a
(2)

Report
Copy link

Link copied!

Use Convert text to number on each separate value from the %DataTableMatches% variable.
-------------------------------------------------------------------------
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