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

Office 365 Outlook new emails to excel spreadsheet

Hi,

I am trying to add a Office 365 Outlook mail to a spreadsheet. The spreadsheet is not being populated and there is no run history. Can you help?

Thank you

 

 

 

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

Hi @jshinabe,

 

Which data that you would like the spreadsheet to keep for the incoming Emails from Office 365 Outlook?

In order to make it work, we need to pre-define a table within the Excel, add the corresponding fields, which are used to store the Email Data.

There is a template available for track Outlook.com email into Excel, the instruction is as below:

"

Whenever you get a new email to your Outlook.com address, track it in an Excel spreadsheet. You need to have a Table with Subject, From, CC and Received Time columns.

"

So if you would like the Office 365 Outlook to work in a similar way, then please add a table with the corresponding fields.

Note that currently only the Online services listed below support Excel connector under Microsoft Flow:

46.PNG

Besides, if you would like to save Email as MSG file, then currently this is not available, there is an idea submitted on this already:

Ability to extract email as MSG or EML file from various Flow mail services

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I cannot figure out which new connection to choose from the drop down box (dropbox, blog storgage, file storage, onedrive....) I'm lost. I want to place certain emails I recieve in outlook into an Excel spreedsheet. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,884)