Finding the Reply to date in the Exchange server connection

[alangenfeld]

The ability to connect to an Exchange server is fatastic.  Has anyone found a place where the "Replied to" timestamp resides in the data connection?

[arify · Accepted solution]

Also there's an attribute called IconIndex in the Attributes Record column, you can also add a check where the received email has that flag value "MailReplied", so that you won't have to do a search for emails that weren't replied to.

[alangenfeld · Accepted solution]

Thank you both for the suggestions; I will attempt both shortly.  Ideally I was trying to create a calculated column from time of the origional email to the timestamp it was replied to.  This would allow me to monitor the response times under various conditions for a team email box.  These methods may allow me to get there with an extra step or two I hope.

[v-shex-msft]

Hi @alangenfeld,

Based on test, I can't find the “Replied to timestamp”. Since the mail table stored the “DateTimeReceived” and “DateTimeSent”, you can refer to below formula to get the “DateTimeSent” as the “replied to timestamp”.

Table = FILTER(Mail, AND(ISERROR(SEARCH("Sent Items", Mail[Folder Path]))=FALSE(),ISERROR(SEARCH("RE:", Mail[Subject]))=FALSE()))

Notice: The formula is used to filter the table which “folder path” is “send items” and “subject” contains “RE:”, the “DateTimeSent” is the “replied to timestamp”.

Regards,
Xiaoxin Sheng

[arify · Accepted solution]

Also there's an attribute called IconIndex in the Attributes Record column, you can also add a check where the received email has that flag value "MailReplied", so that you won't have to do a search for emails that weren't replied to.

[Maha1]

How about if the email was forwarded? I tried a test and got "Default", does this mean Forward?

[danextian]

Hi @arify,

I am currently exploring a shared inbox in outlook. We are trying to compute the time from when an email was received up to when it was first replied to.  I can't seem to find where MailReplied is. Is it in Attributes?

[Wkbdrguy]

Looking to do the samething. Did this ever get figured out?

[Maha1]

@Wkbdrguy @danextian Expand "Attributes" Column and choose IconIndex. "MailReplied" is the value inside the cell

[danextian]

I figured a solution to it but it is kind of complex and I don't have a copy of the PBIX anymore since I left my previous company. One thing's for sure: connecting to OWA can be very slow.