Forum Discussion

alangenfeld's avatar
alangenfeld
Frequent Visitor
9 years ago
Solved

Finding the Reply to date in the Exchange server connection

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's avatar
    arify
    9 years ago

    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's avatar
    alangenfeld
    9 years ago

    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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      arify
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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.

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        7 years ago

        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?

  • alangenfeld's avatar
    alangenfeld
    Frequent Visitor
    9 years ago

    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.