Copying excel data from attachment in email into excel workbook (copying data from one excel file to another excel file)

Hello,

I am trying to automate a process by building a flow which receives an email with an excel attachment and copies the data from that attachment into an existing excel file worksheet. I am able to trigger the flow with an email easily. I am struggling with copying the contents from that file to a different file which feels like it should be simple.

I have tried using list rows present in table and adding a new row for every line in the file, but the files I will be receiving with be 1000s of rows long so it takes way too long. I also had to make the original worksheet a table which ruined it being automated.

I have also tried creating a new file in my SharePoint library and getting the content from the emailed file but I do not know how to get the data from there to the file where I need the data to go. I have looked at using excel scripts, are they efficient?

Does anyone know an efficient way I could do this with power automate with the help of excel office scripts or any other method? Thank you.

Quick Links

Leaderboard > Power Automate