web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Moving rows from new w...
Power Automate
Unanswered

Moving rows from new worksheet to existing 'master' worksheet

(0) ShareShare
ReportReport
Posted on by

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.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard