Answered

Power Automate Desktop - loaded CSV to Dataset, For each - CurrentItem - is there a Row Number property?

(0) Share

Report

Posted on by charles_ross_oh

I have loaded a CSV file using "Read from CSV file" and this produces the variable "CSVTable" which is a Datatable. Then I am going thru the items in the data table with a "For each" loop , which places each row from "CSVTable" in the variable "CurrentItem".

Is there some internal variable (something like "CurrentRow") that can tell me the Data table row number property of "CurrentItem"?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Make sure you tell "Read from CSV file" if the first row is titles, so the first row [0] is actual data. The syntax for getting a specific data sets is %CSVTable[Row][Column]%. So, if you wanted the 3rd column from the first row, just remember that they both start with 0, so it would be %CSVDataTable[0,2]%.

For something like, for each row, do XYZ, I would use a loop instead of For Each:

Loop Starting at 0 ending at %CSVTable.RowsCount% increment by 1.
Then you can say %CSVTable[LoopIndex][2]% to get the 3rd column of the row indicated by the LoopIndex.

Good luck.

Was this reply helpful? Yes No
charles_ross_oh 91 on at

Like
a
(0)

Report
Copy link

Link copied!

These are good tips, thanks. However those are not answers to the question I posted., which is for a current row property.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You asked for a way to get through each row with a variable that could be used for a row index. I gave you an example of how to do a Loop where %LoopIndex% is the row variable.

Was this reply helpful? Yes No
Verified answer

tkuehara 667 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @charles_ross_oh

There's no "current row index" property when running a for each loop. You need to create a variable and increase it manually.
Or, alternatively, rewrite the code to run a simple loop and therefore you'll have the built-in index variable in it as suggested by @MichaelAnnis. Please notice though that the loop index might not match with your data source (in the example above, an Excel file) row, so you'll still need to adjust it according to your needs.

Was this reply helpful? Yes No