Using Power automate to auto update a spreadsheet with excel attachment received in email each day

[ckieffer2]

Hi,

I am pretty new to power automate so not exactly sure how to do set up the workflow. Every day I receive an email that has an excel attachment with data. Normally, I would manually download that attachment and copy paste the data into a separate spreadsheet (Spreadsheet X) I created. I wait for the formulas to update and then I send out the spreadsheet via email. Is there any way to make it so this whole process is automated? I.E. the attachment is downloaded from the spreadsheet each day and the data is pasted into Spreadsheet X...then the formulas are updated with the new data and Spreadsheet X is saved and sent out in an email. I am playing around with it trying to get it to work but any help would be much appreciated!!

Thanks

[v-chengfen-msft · Accepted solution]

Hi @ckieffer2 ,

Do you want:
1. When you receive an email, get the excel file in the email attachment
2. Dynamically fill the content of the excel file into another excel file
3. Email the completed excel file as an attachment

Here is test for your reference:

Here is result:

Here is email file:

Best Regards

Cheng Feng