cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arhetyp Regular Visitor
Regular Visitor

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

 

 

10 REPLIES 10
v-jiascu-msft Super Contributor
Super Contributor

Re: Outlook: how to link Inbox & Sent Items

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
arhetyp Regular Visitor
Regular Visitor

Re: Outlook: how to link Inbox & Sent Items

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?Smiley Happy

 

Regards,
Arek

v-jiascu-msft Super Contributor
Super Contributor

Re: Outlook: how to link Inbox & Sent Items

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
arhetyp Regular Visitor
Regular Visitor

Re: Outlook: how to link Inbox & Sent Items

Hmm...

I am afraid I did not get itSmiley Happy

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

 

Cheers,

Arek

v-jiascu-msft Super Contributor
Super Contributor

Re: Outlook: how to link Inbox & Sent Items

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.

how_to_link_Inbox_Sent_Items

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
arhetyp Regular Visitor
Regular Visitor

Re: Outlook: how to link Inbox & Sent Items

Hi Dale,

 

attributes are the same, at least here we are at the same pageSmiley Happy

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:

 

 

Relation+want.png

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

 

image.png

 

 

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

image.png

Am I doing sth incorrectly?

 

Regards,

Arek

arhetyp Regular Visitor
Regular Visitor

Re: Outlook: how to link Inbox & Sent Items

HiSmiley Happy

 

can Dale or anyone advise with that issue?Smiley Happy

 

Regards,

Arek

v-jiascu-msft Super Contributor
Super Contributor

Re: Outlook: how to link Inbox & Sent Items

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. 

image

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anandareddy Frequent Visitor
Frequent Visitor

Re: Outlook: how to link Inbox & Sent Items

Thanks for the logic shared!

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 134 members 1,602 guests
Please welcome our newest community members: