We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

Using a MultiList Option Lookup

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.

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

Reset Filters