Moving rows from new worksheet to existing 'master' worksheet

(0) Share

Report

Posted on by huber57

Hello all, I am new to Power Automate and I hope you can help.

I have a master spreadsheet where I store transaction data. Each day, I receive an email with the previous days' transactions. I would like to move the daily report into a master spreadsheet so I can then pivot all of the data together. The data coming in is not formatted as a table (currently) and is does not start in cell A1 (it starts in cell A8). The daily report length (# of rows) varies each day.

Can someone point me in the right direction on how to facilitate moving the data from one spreadsheet to another?

Thanks!

Doug

P.S. my plan is to trigger this by saving the daily spreadsheet to a folder in OneDrive. Once the flow completes (and the data is moved), I would like PowerAutomate to delete the daily file.