cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joannecheong
New Member

Copy excel contents from email attachment to another excel workbook in SP

I get an attachment excel file daily from my Outlook email, and I have to copy and paste the excel content into a central/template excel file. I want to do this all in SP. What objects or steps do I need to achieve this?

5 REPLIES 5
efialttes
Super User
Super User

Hi!
I would split your challenge on different steps. For the first one, archive excel attachment... I would suggest you to have a look to this template and verify if it matches your requirements
https://flow.microsoft.com/en-us/galleries/public/templates/f7a46809e53c42108034e56acf83bb79/save-my...
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Yes! I started building my flow with that template. I took email attachments and created a SharePoint file. However, now I'm stuck on the next step which is to copy the contents of that newly created SharePoint file into a template excel file that is also on SharePoint.

Hi again
Haven't tested myself, but according to this thread it is possible to read content of an excel file uploaded to onedrive by means of a second flow triggered when a file is created

https://powerusers.microsoft.com/t5/General-Power-Automate/Get-rows-from-latest-Excel-file-in-folder...

Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@joannecheong 

The second flow approach, tested and working as expected

Flow_ReadDynamicExcelTable.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@joannecheong 

Did you have time to implement and test my suggestion?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,499)