1. On the Integration tab click on Additional Columns tab.
2. Click on the Add Additional Column button.

3. The Additional Column window will open.
4. Name – Enter a name for the column.
5. Tab off the Name field to enable the Type field.
6. Type – Select MultiList Option Lookup from the Type dropdown list.

‍

7. Entity – Select the entity that contains the required list option.
8. Picklist – Select the required list of options.
9. Column Name – Select the source column(s) that contain the data to be looked up within the CRM Server.
10. Delimiter – Select the delimiter used in the source column for the multiple options.
11. 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.

12. Default Value – If “Return default value” has been selected, enter the default value to be returned.
13. Save the column settings.