
Announcements
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.
Hi @cecilia123
Have you tried this?
first you download attachments or use get attachments then use get file content and create a file with whatever the name is required and in the create file give the content file content from the get file content.
Hope this helps
Usha