E-mail data analyse

[Gustavonjr]

Good morning, I have the task of creating a dashboard in Power Bi that reads emails from the inbox and determines the average response time for that user, however I am not identifying the necessary fields, date and time that the email was responded to, could you Help me with this and/or if you have a .pbix it will be of great help.

[rajendraongole1]

Hi @Gustavonjr - To extract emails from an inbox, you can use Microsoft Graph API or Office 365 Outlook connector in Power Automate to fetch the necessary data.

Create a Flow in Power Automate>>Trigger: When a new email arrives (V3)>>Action: Get email (V2) >>Action: Parse JSON (to structure the email data)

Once you have the email data stored in either SharePoint or SQL, you need to connect Power BI to this data source and calculate the response times.

Microsoft Reference Links:

Office 365 Outlook - Connectors | Microsoft Learn

https://docs.microsoft.com/en-us/graph/api/user-list-messages?view=graph-rest-1.0&tabs=http

How To Parse Emails and Populate SharePoint Lists Using Power Automate - YouTube

By following the above documents and reference , you can track the reads emails, calculates response times using measure with (Average function) , and visualizes the data effectively in power bi.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Gustavonjr]

Thanks for the feedback, however, wouldn't it be possible to do this with power query connecting to Microsoft Exchange and pulling the email data?

[rajendraongole1]

Hi @Gustavonjr - Yes possible , you can extract it from Microsoft exchange source (Online)

Get Data >> More >> Search with Exchange>> Microsoft Exchange>> Connect

you can load required tables like calendar, mails, contacts and so on. filter the data based on received time , to ,from, body, subject as categories. 

Hope it works, please check and let know

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Gustavonjr]

Yes, I was able to connect, I just have one question, if you know how to answer me, of course, I haven't identified how I can do the response time for this email (know how long it took for them to respond) I only have the date of receipt and not the date of response

[rajendraongole1]

Hi @Gustavonjr - you can consider the datetime received and try to build the further analysis.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!