Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
This third part of the Server-Side Sync blog series will focus on what correlation is and how to view Exchange item properties.
What is correlation?
For Dynamics 365, correlation is a set of checks to determine if an email matches any condition that is configured by an end user to automatically promote an Exchange item into Dynamics.
Remember that "promotion" in this context doesn't mean a change in rank, it means the attempted creation of an activity record within Dynamics (such as an Emails or Appointments) using data within an Exchange item.
How is Correlation configured?
When setting up Server-Side Sync for the first time, InReplyTo correlation is configured by default for user mailboxes. There are two areas within Dynamics 365 where this is controlled, the organization-level System Settings and the user-level personalization options.
System Settings-> Email:
The "Use correlation to track email conversations" checkbox allows Server-Side Sync to evaluate emails to determine if they match any correlation method setup within the organization. You'll notice some others available for selection here, such as Tracking Token and Smart Matching, which we will discuss later in this series.
User-Level Personalization Settings -> Email
The value for each user is by default set to "Email messages in response to Dynamics 365 email" upon user record creation. This value means that it will use InReplyTo correlation when determining whether to not to automatically create an Email record in Dynamics using values from the email sitting within the Exchange Inbox.
How are emails stored in Dynamics? What fields does Server-Side Sync evaluate?
Recall in the previous entry in our series that Emails within Dynamics have a "MessageID" field that contains a unique, duplicate constrained value. Activity records such as emails are stored on the ActivityPointerBase in SQL, where the MessageID exists as one of the columns for each record. This Message ID conforms to the format "<firstname.lastname@example.org>", including the greater than and less than symbols around the data. A real example of a Message ID would look like this:
Now that we understand that these unique Message ID values are stored in SQL for each activity item, we can then examine how Exchange handles forwards and replies. For every Exchange item, behind-the-scenes values can be examined that give more data on the individual properties that define what the item is. These values can be basic data such as subject, body, recipients, and received time, but also contain more esoteric properties such as messageid, references, thread-index and content-type.
These properties can be accessed multiple different ways, but the most common is to view the message headers of the item in Outlook/OWA or to use an application such as EWS editor to be able to examine the properties of items in a mailbox directly. Here is an example of a section of message headers for an email I sent through Dynamics:
From: Cody Dinwiddie <codin@OBFUSCATED.onmicrosoft.com>To: Cody Dinwiddie <email@example.com>Subject: [EXTERNAL] Test EmailThread-Topic: Test EmailThread-Index: AQscuKgXz0bUld+ni9oW2WvWgJcWog==Date: Tue, 1 Sep 2020 19:35:55 +0000Message-ID:<142408F2977449AE9A3EB234870D156A1D6809716A2B@CODIN.OBFUSCATED.ONMICROSOFT.COM>Accept-Language: en-US
Since this message was sent through Dynamics, I know that there is an ActivityPointerBase record in Dynamics SQL that contains all of the values the email uses including the MessageID above. In fact, I can do an advanced find to find the email based on the Message ID:
Now the we understand how Dynamics stores emails and that Exchange items have properties that can be examined, we will explore In-Reply-To Correlation in the next entry in our series.
Part 1, Part 2, Part 4
Business Applications communities