Knowledge Base

Using a MultiList Option Lookup

How can we help?

Browse Common Categories

Getting Started with

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 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.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?