Re: Repeat "Copy cells from Excel Worksheet" but change row on every repeat
Hi @BruKn0ws
The flow is not actually updating anything in my excel sheet. It's just reading the row/cell
The approach that I have suggested of writing to an Excel in a temporary cell is called as using a Helper cell.
You can do the same within a PAD variable also. But it can be used only till the flow is running. If you need this variable on the next day then you need to store it in an Excel cell as I have suggested above. I leave this option to you.
"Once you have finished "Copy cells" then go and update this value (in this example 2)." - I would need this to be automated as well
I am suggesting you to do this in an automated way via PAD to update the cell and not manually.
Is there a way to do an "if" and read the cell/value, so that if the cell/value is empty, then stop the flow and if it's not empty, then copy the one below?
Use the If block and
To read a cell you can use "Read from Excel worksheet" action
and to stop the flow you can use the actions under the "Flow control" tab in the actions section.
