Outlook: how to link Inbox & Sent Items

[arhetyp]

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

[v-jiascu-msft]

Hi Arek,

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

Best Regards,

Dale

[arhetyp]

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]

Hi Arek,

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

Best Regards,

Dale

[arhetyp]

Hmm...

I am afraid I did not get it:)

Can you please present how to unique key should look like?

Cheers,

Arek

[v-jiascu-msft]

Hi Arek,

Which email domain do you have? Maybe it has different properties with mine. Please have a look at the column titles. We can expand the attributes to get the result.

Best Regards,

Dale

[arhetyp]

Hi Dale,

attributes are the same, at least here we are at the same page:)

Please let me to explain step by step what is my way of working:

1. 2 tables imported from Exchange - Inbox and relevant Sent Items shared mailboxes.

2. Then I need to assign to each mail from Inbox related Sent date - what I mean by that is to get the date/time when particular mail was actually answered.

3. To make step 2 happen I need to find a 1:1 relation between those two tables:

4. According to your proposal  I created a similar key in both tables:

5. I am afraid this combinations does not ensure us a unique key:

Am I doing sth incorrectly?

Regards,

Arek

[arhetyp]

Hi:)

can Dale or anyone advise with that issue?:)

Regards,

Arek

[v-jiascu-msft]

Hi Arek,

It's hard to create keys. The email system uses the keys to connect the emails. We can use them directly. As can see from your snapshot, the two keys in the blue squares are the same. So they are one pair. 

Then you can establish relationships between the two tables using the keys. Because you import the sent items and the received items in two tables. 

The email systems are different, I can only import all the email in one table. Your scenario is more clear. 

Best Regards,
Dale

[Anonymous]

Hi Arek, 

Please share me sample PowerBi file in which you have built up this logic to calculate the TAT . I am trying this from past one week and not able to find any solution to my current project.

[Anonymous]

Thanks for the logic shared!

Please help us how can we calulcate the TAT for each inbox mail from the steps that you shared.