Multi-Select Option Sets

The Multi-Select Option Set datatype is a picklist that allows a Microsoft Dynamics 365 user to select more than one value from a picklist for a single record. For example, a Multi-Select Option Set named Countries Visited where the user could select one or more countries instead of a single country.

Multi-Select Option Sets are supported only for Microsoft Dynamics 365 Online.
Query and Lookup source operations are supported.
Update and Insert target operations are supported.
When querying records with Multi-Select values, values are returned as a comma separated list of values.
When writing Multi-Select values to a target, they must be formatted as a comma separated list of values.
Multi-Select values are case sensitive.
Each Multi-Select value has both a name and an associated numeric value, just like a picklist. A combination of names and numeric values can be used when mapping to a Multi-Select field.
Updating multi-select values on a record, overwrites existing values. To append new values to an existing record, use a Lookup to get the existing values and append the new values to the existing list.
Retrieving Multi-Select Option Set values and filtering via the Microsoft Dynamics 365 and CRM Publisher is supported.
The Validate Dynamics 365 Picklist Fields option in adapter settings is not supported.
Filtering for Multi-Select values in the DTS is not supported.
The Test Window and Formula Editor can only display 255 characters. If your Multi-Select values exceed 255 you cannot display them, however, when the DTS runs, longer values are processed correctly.

Note:

If a value in a Multi-Select Option Set field contains a comma or a quote, the value displayed in TIBCO Scribe® Insight contains escape characters. For example, Yell,ow displays as Yell,ow, and Yell"ow displays as Yell"ow.