Loop through each row in excel

(0) Share

Report

Posted on by tracyannkenney

Hi -I have a data table loaded from excel storing info I use to input in SAP.

I need a loop to go through each row to get each cell to populate a UI element created.

What is the best way to do this?

***I was creating a list for each column and was planning to loop through, but I don't think that will work. I need it to look through each row. There is no "Get Rows" action available in Power Automate Desktop

Thanks in advance!

@loop @excel @rows

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report

The For each loop creates a dynamic %CurrentItem% variable with named cells (if you turn on headers in the advanced option of your Read from Excel worksheet. This means that you can pull out the exact data that you need each round, by writing something like %CurrentItem['ID number']% in your Populate text field action.

Was this reply helpful? Yes No
tracyannkenney 6 on at

Like (0)

Report

I do not see that option

Was this reply helpful? Yes No
Canjun 12 on at

Like (0)

Report

Hi Henrik,
I think I'm having a similar issue with the for each loop. Even The data table has 0 inside, the if condition wouldn't pop up any message

Was this reply helpful? Yes No
tracyannkenney 6 on at

Like (0)

Report

I do not see that option. I do see "First line of range is column name".
I still need help with the steps. I want each cell in the row input in SAP, run the transaction, then loop back and do the next row. Each row has 6 inputs. I only understand how to loop 1 input.

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report

You have the right option selected.

Headers usually default to Column1, Column2, etc. when your start row is blank.

Start row should be the header row.

What does your Excel file look like?

Was this reply helpful? Yes No
tracyannkenney 6 on at

Like (0)

Report

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report

If you run the same Read action on that sheet, the column headers should show Posting Date From, Posting Date To, etc... which you can then use in the loop: %CurrentItem['Posting Date To']%

Was this reply helpful? Yes No
vaibhavtandon87 182 on at

Like (0)

Report

@trax , did this work? I am in a similar fix to loop through Excel data on a web form / SAP screen

Was this reply helpful? Yes No