Using a MultiList Option Lookup

Published: Mar 14, 2023

Using a MultiList Option Lookup

Published: Mar 14, 2023
  1. On the Integration tab click on Additional Columns tab.
  2. Click on the Add Additional Column button.
63c5abace9f2c765da31d7b4 AddAdditionalColumnButton
  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.
63cad91bfab08a6ca4079f70 CEMultiListOption

  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 the CRM Server.
  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

Reset Filters