Say I have an Excel file with a variable number of rows, but the same number of columns.
I need to extract the data from the specific columns in each row and set that cell value to a variable.
So far this is what I have to select the used range, but I'm stuck on the For Each loop.
I've used Message Boxes to confirm the For Each loop is iterating through each row, but how do I access a specific element of that row?
For instance, in my For Each loops, I want set 4 different variables, one to each value from each column of that row. I can't figure out how to access the specific column's value.
In the Flow variables, I see I can expand CurrentItem to select some elements, but not how to reference a column.
So another idea I had was to Split the row to generate a List, but then I ran into the same problem of how to access an element in that list. Like if I was using Python, the List's Index[0] would end up as the first column, Index[1] would be the second column...
Any suggestions on how to accomplish this?
