Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello I am trying to see a turn around time from when an email is received to when we reply on it. When I pull the MS outlook exchange data, I see when the email is sent, recieved, but I do not see a date of (if we replied on it). I tried to look by id column but didn't find any relationship between the emails. Any other thoughts?
Solved! Go to Solution.
@jcastr02 - I think you would need to duplicate the original 'Mail' table and then filter the result to ([Folder Path] = "\Sent Items\").
Then you can Merge both tables where you join 'Mail Sent' with 'Mail' on [Id].
Proud to be a Super User!
@ChrisMendoza Thanks that helps - do you know where the actual Sent time would be captured for that email?
@jcastr02 - I was wrong, sorry I didn't test a little more thoroughly. This is actually not as easy as I had thought. You'll actually need to expand [Attributes] to get to [InternetMessageId]. Also in [Attributes] is [InReplyTo] which I'm sure you'll find useful. I chose this sample to show how difficult this may become:
Here are teh queries and the join:
Proud to be a Super User!
Thanks @ChrisMendoza it looks though as the reply email has the same sent/received date/time as the original email. I am looking for the time the email was replied to (sent back). Any ideas?
@jcastr02 - I don't understand what you mean? In this sample, the incoming mail was sent 3/25 and the reply was 3/27.
Proud to be a Super User!
Chris, May I please ask a question? I am trying to do the same and what I did was to geta blank workbook, get the data from Exchange, leave only the columns I need plus those from Attributes. Did you seperate the queries? Like bringing in first the data about the sender and after created a new query and bought from Attributes onwards and after merged? Sorry for the silly question but this is my first time trying this. Thanks so much
I'm pretty sure I duplicated the Mail query and then joined on [Attributes.InternetMessageId]
Proud to be a Super User!
Thank you so much! I will give it a try
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |