Hello Everyone,
Looking on help on how to save an Excel attachment that sent daily through email and save it to one Sharepoint list.
-Sharepoint list has the same headers as Excel attachment
-Need new items copied from email Excel attachment to replace and delete any old items on the share-point list to make sure I always have the most updated information.
-Same sender and email subject
Any idea how to use power automate to do this?
Thank you!
I actually figured it out, file is replaced because its the same file name, so that works.
The only thing is now the file is a list, not formatted as a table. Anyway power automate can download and format as table?
Thank you again for all your help!
So for the "/" where is it saving or do i need to save it to a file? also, for get a row, it is an excel sheet but then i need it send over to the sharepoint list.
Is there away I can save the excel sheet that comes in the email attachment in a file in the one drive and everytime a new email comes have it replace automatically? maybe thats easier?
Hello @manuelstgomes ,
Thank you for all your help.
The list is a roster of names and different departments there in. whole list changes daily but there are times that it could be the same employees name there. The main header names though is always the same.
I will try you method and get back to you.
Thanks!
Hi @Sahara22
It's not a simple Flow, but we can try to do it. Do you already have something built?
I would do the following:
Is this what you need?
Cheers
Manuel
------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. 👍
Otherwise, reply to it, and the community will do its best to help you.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1