Power Automate Flow for Copy-Pasting data in Excel

(0) Share

Report

Posted on by Sud12

Hey everyone,

How to create a power automate flow where I have an excel tab with fixed data (say columns G to O). Now this row of data is to be just dragged down and copied until the row which contains a pre-existing data. For example G2 to O2 already filled with data. The same needs to be copied and pasted down until G9 to O9. It must stop at G9-O9 since G10-O10 contains again pre-filled row of data. No this data needs to be copied and pasted until G21-O21 and so on until it finds no fresh data in the first column A (which has the unique ID).

Any inputs on which conditions can be used in power automate or how to proceed with this?

Thanks