Share
Report
13Hello,
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.
All responses (
Answers (
