Forum Discussion

alangenfeld's avatar
alangenfeld
Frequent Visitor
10 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
    10 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
    10 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
    10 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
      10 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
    10 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.