Repeat "Copy cells from Excel Worksheet" but change row on every repeat

[BruKn0ws]

Hi all.

As per the subject, I'm trying to copy individual cells from a column and pasting it to a CorelDraw file. I tried to find a way that every time I run this subflow, the next row is selected and the subflow starts over.

 I'm not sure how to finish the subflow so that it starts over and selects D3 instead of D2 again. 

Thank you!

[VJR]

Hi @BruKn0ws 

For your future reference this link is for Power Automate Desktop  where you can get more help.

Somewhere in your sheet in a far away column that is not visible to the user, maintain a record of the last row that was updated.

Once you have finished "Copy cells" then go and update this value (in this example 2).

Add a check in the beginning of your flow so that it reads this cell value and increments the row number each time.

So the next time your "Copy cells" will be D3.

[BruKn0ws]

Hi VJR,

The flow is not actually updating anything in my excel sheet. It's just reading the row/cell and pasting it in a CorelDraw.

"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'll have to run the sub flow at least 120 times so that it copies each row and pastes it into a CorelDraw file. So, it would finish the subflow, then run again starting on the next row until it reached an empty row.

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?

[VJR]

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.

[BruKn0ws]

Thanks for the fast reply! Going to try it today and let you know the results.