Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
jcastr02
Post Prodigy
Post Prodigy

Outlook data - Reply to an email

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?

1 ACCEPTED SOLUTION

I see it now, thanks @ChrisMendoza for your help.

View solution in original post

9 REPLIES 9
ChrisMendoza
Resident Rockstar
Resident Rockstar

@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].






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

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:

image.png

Here are teh queries and the join:

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

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. 

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

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]






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Thank you so much! I will give it a try

I see it now, thanks @ChrisMendoza for your help.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.