Forum Discussion
E-mail data analyse
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!!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
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!!