Forum Discussion
E-mail data analyse
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.
5 Replies
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!!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?
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!!
