Forum Discussion

arhetyp's avatar
arhetyp
Icon for Helper I rankHelper I
7 years ago

Outlook: how to link Inbox & Sent Items

Hi,

 

I need to calculate turnover time from mail receipt to mail response.

My issues is: how to link message from Inbox folder with the relevant message that was an answer?

 

Which parameters might be used to create a unique key/relation between Inbox and Sent folders?

I have checked them all in Power BI and any of them seems to be unique.

 

I would greatly appreciate if someone can share his experience on that.

 

Regards,

Arek

 

 

Need Help

10 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Arek,

     

    You can expand the Attributes in the Query editor. Then you can link them with "Conversation topic". Please give it a try.

    Outlook_how_to_link_Inbox_Sent_Items

     

    Best Regards,

    Dale

    • arhetyp's avatar
      arhetyp
      Icon for Helper I rankHelper I
      7 years ago

      Hi Dale,

       

      I thought about that one but I am afraid it will might not be sufficient, I have even thougt to merge it with size of mail or even size of attachment but this still can not give me the unique key.

       

      The point is the shared mailbox will be used for daily operations, a majority of mails will come with similar name "Request" etc.

       

      Is there maybe any simpler and more acurate solutions?:)

       

      Regards,
      Arek

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Arek,

         

        Yes, the two fields in the snapshot, Attributes.References and Attributes.InternetMessageID, connect each other accurately. Please give it a try.

        Outlook_how_to_link_Inbox_Sent_Items2

         

         

         

        Best Regards,

        Dale