Unanswered

Export Email Data

(0) Share

Report

Posted on by DanielGAJohnson

Hi All,

I'm new to Power Automate, but I think this might help me with what I'm trying to do. My company uses Office for email and I would like to create a data lake of email data in SharePoint from many users. From that data lake I would use Power BI to do company-wide analytics on things like email response rate, or most popular day people respond to our emails, stuff like that. Is there a way to use Power Automate on a group of colleagues so that once a week a .pst or .xlsx or .csv file of their email data is automatically uploaded into a SharePoint folder? I know that in Power BI there is an Exchange server connector that allows me to see my inbox's data, but I haven't seen a way to add colleagues data automatically. I understand this might mean me going 1-by1 to each colleague and setting this up in Power Automate, but I'm OK with that. Let's use me as a guinea pig for now. The data I'm looking to have Power Automate export would have to included timestamps and a particular data field called "InternetMessageID." That last field is found in the "Attributes" column in Power BI after connecting your Exchange server with Power BI. Like I said, I'm new to Power Automate, so any advice would be greatly appreciated.

Thanks,

Daniel

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DanielGAJohnson
Please check the below link it can be a great start.
https://flow.microsoft.com/en-us/galleries/public/templates/f7a46809e53c42108034e56acf83bb79/save-my-email-attachments-to-a-sharepoint-document-library/

Was this reply helpful? Yes No
DanielGAJohnson 93 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DanielGAJohnson
Sorry just updated my reply

Was this reply helpful? Yes No
DanielGAJohnson 93 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly Not sure this will help me. I'm looking to do a weekly export to a file like .csv or .xlsx. I'm not so much interested in attachments or individual emails. I am looking to do data analysis on potentially thousands of emails a week. And the emails are almost always sent to unique addresses.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DanielGAJohnson
Sorry got you wrong, please check the Get Emails action and then you can loop on the output using apply to each, Add row to an Excel action.

I can provide you with an example shortly.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DanielGAJohnson
GetEmails, you can specifiy more than one user and specify which folder and also search criteria if you need such.
Then you can add it to an excel row as below but please note it will be adding it as HTML so may be you will need to parse the email body before adding it.

Hop this helps!

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@DanielGAJohnson

Please note that Get emails will return a maximum of 250 emails. You said that you might be looking at thousands of emails each week. I suspect that you'll need to use a search query and retrieve emails in batches for this to work for you.

Here is a link to the Get Emails documentation.

Was this reply helpful? Yes No