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
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.
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
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.
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?
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']%