I have a desktop flow that needs to read from an Excel worksheet, goes through each row of data (using For each), then has to write to Excel worksheet on a specific column but on the current row where the For each is currently at. What can I put into the Row area of the Write to Excel worksheet action so I can refer to the %CurrentItem% row? Is there a way to do this without counting the row number in a variable? There must be some system information on what row you are currently at, it seems silly to have to create a row counter to accomplish this when the system knows what row it is at...
