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

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-chengfen-msft
Microsoft
Microsoft

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:

vchengfenmsft_0-1669861264513.pngvchengfenmsft_1-1669861273543.png

vchengfenmsft_3-1669862082331.png

vchengfenmsft_4-1669862114805.png

 

Here is result:

 

Here is email file:

vchengfenmsft_2-1669861793589.png

 

vchengfenmsft_1-1669861774167.png
 

 

Best Regards

Cheng Feng

View solution in original post

1 REPLY 1
v-chengfen-msft
Microsoft
Microsoft

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:

vchengfenmsft_0-1669861264513.pngvchengfenmsft_1-1669861273543.png

vchengfenmsft_3-1669862082331.png

vchengfenmsft_4-1669862114805.png

 

Here is result:

 

Here is email file:

vchengfenmsft_2-1669861793589.png

 

vchengfenmsft_1-1669861774167.png
 

 

Best Regards

Cheng Feng

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,661)