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

Microsoft Dynamics 365 for Operations lookups in synchronization tasks

You can create lookups for objects in Microsoft Dynamics 365 for Operations connection. You can retrieve data from a Microsoft Dynamics 365 for Operations lookup object based on the specified lookup condition.
When you configure a lookup in Microsoft Dynamics 365 for Operations, 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 Operations 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.
Number of rows to read
Fetches the number of rows specified.
Number of rows to skip
Sets the number of rows you can skip.
Page Size
Size of the page set to retrieve the maximum number of entries for each page.
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.
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
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.
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