Using a MultiList Option Lookup

  1. On the Integration tab click on Additional Columns tab.
  2. Click on the Add Additional Column button.
  1. The Additional Column window will open.
  2. Name – Enter a name for the column.
  3. Tab off the Name field to enable the Type field.
  4. Type – Select MultiList Option Lookup from the Type dropdown list.

  1. Entity – Select the entity that contains the required list option.
  2. Picklist – Select the required list of options.
  3. Column Name – Select the source column(s) that contain the data to be looked up within Dynamics 365 Customer Engagement.
  4. Delimiter – Select the delimiter used in the source column for the multiple options.
  5. If No Data – Select the required option if not data is found when filtering lookup values with the supplied value
  • Continue – SmartConnect will continue the integration even if no data is found.
  • Return default value – SmartConnect will return a default value for the option set if the supplied value does not match a value in the option list.
  • Return failure for current integration line – SmartConnect will return a failure of the current integration line if no data was found.
  • Stop processing integrations – SmartConnect will stop processing if the supplied value does not match a value in the option list.
  1. Default Value – If “Return default value” has been selected, enter the default value to be returned.
  2. Save the column settings.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.