Forum Discussion
Finding the Reply to date in the Exchange server connection
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.
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.
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
Microsoft EmployeeAlso 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.
Maha1Helper II
How about if the email was forwarded? I tried a test and got "Default", does this mean Forward?
