Microsoft Dynamics 365 for Sales Connector > Synchronization tasks with Microsoft Dynamics 365 for Sales Connector > Microsoft Dynamics 365 for Sales lookups in synchronization tasks
  

Microsoft Dynamics 365 for Sales lookups in synchronization tasks

You can create lookups for objects in a Microsoft Dynamics 365 for Sales connection. You can retrieve data from a Microsoft Dynamics 365 for Sales lookup object based on the specified lookup condition.
When you configure a lookup in Microsoft Dynamics 365 for Sales, you select the lookup connection and lookup object. You also define the behavior when a lookup condition returns more than one match.
The following table describes the Microsoft Dynamics 365 for Sales lookup object properties that you can configure in a Lookup transformation in synchronization tasks:
Property
Description
Lookup Connection
Name of the lookup connection.
Lookup Object
Name of the lookup object for the synchronization task.
Row Limit
The maximum number of rows that the Secure Agent processes. Specify a number to process a specific number of rows.
Page Size
Size of the page set to retrieve the maximum number of entries for each page. Default value is 100.
Display technical names instead of labels
Displays technical names instead of business names.
Display fields in alphabetical order
Displays lookup fields in alphabetical order instead of the order returned by the source system.
Lookup Fields
The fields used to define the lookup condition. Select Source Fields and Lookup Fields.
The synchronization task compares the value of the source field against the lookup field, and then returns a value based on the match. You can define multiple conditions in a lookup. If you define more than one lookup condition, all lookup conditions must be true to find the match.
Note: A Lookup transformation in a synchronization task is uncached.
The following table describes the lookup return value properties that you can configure:
Lookup Return Value Property
Description
Output Field
The field from the lookup table that you want to use.
Multiplicity
Defines how the synchronization task handles multiple return values. Select one of the following values:
  • - Error, if more than one output value. Select if the synchronization task should display an error when the lookup condition returns multiple values. The synchronization task rejects rows when multiple matches are found, writing them to the error rows file. This is the default.
  • - Randomly pick one output value. Select if the synchronization task should choose the first returned value when a lookup condition returns multiple values. Different systems might use different orders to return lookup values.
  • Note: When you select Randomly pick one output value and more than 20 records match the lookup condition, an error appears and the Secure Agent does not write any records to the next transformation.
Expression
A simple expression that uses $OutputField to represent the selected output field.
By default, synchronization tasks pass the lookup return value without alteration with the following expression:
$OutputField