Retrive cell value from For Each Loop

(0) Share

Report

Posted on by dahlgebra

119

Table name: excelData

Code	Status
123
434
343

I have a "For each" loop with "excelData" as input. For the first iteration I should be able to access the cell: "123". How can i accomplish that? I have used the following code without any luck.

%CurrentItem[1][0]%

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

fraenK 2,125 on at

Like (1)

Report

If you loop through a data table, then CurrentItem represents a data row. So there are only columns you can access.
%CurrentItem[0]% for the first column value
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-types

Was this reply helpful? Yes No
dahlgebra 119 on at

Like (0)

Report

Hi,

Thanks for a quick reply. I realized the fact that you only deal with one row when you do a loop right after posting the message. So for the current example you can access the mentioned value with on of these lines, Right?

- %CurrentItem['Code']%
- %CurrentItem[0]%

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

Like (0)

Report

Don't think that CurrentItem will hold the name of the columns, so if you want to access the column values by name then you need to loop through the table using the row index %ExcelData[0]['Code']% instead of for each.
https://docs.microsoft.com/en-us/previous-versions/troubleshoot/winautomation/process-development-tips/variables/how-to-retrieve-list-item-datatable-cell

Was this reply helpful? Yes No
dahlgebra 119 on at

Like (1)

Report

I think they will hold the name of the columns 🙂

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

Like (0)

Report

You're right, the column headers are carried over

Was this reply helpful? Yes No