MultiSelectPickListOptions
Contains the possible selectable options for MultiSelect OptionSet attributes, enabling multi-value selections.
View-Specific Information
Select
The server will use the Microsoft Dataverse API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the server.
- TableName supports '=','IN' operators.
Note that without filtering on TableName, the server returns the results for the first table found.
For example, the following queries are processed server side:
SELECT * FROM MultiSelectPickListOptions WHERE TableName = 'teams'
SELECT * FROM MultiSelectPickListOptions WHERE TableName IN ('accounts', 'teams')
Columns
| Name | Type | References | Description |
| ColumnName | String |
MultiSelectPickListAttributeMetaData.ColumnName | The name of the column in the table where the multi-select picklist option is defined. |
| Color | String | The color code associated with the picklist option, often used for UI display purposes. | |
| ExternalValue | String | An external system value mapped to this picklist option, if applicable. | |
| HasChanged | String | Indicates whether the option has been modified since its creation or last update. | |
| IsManaged | Boolean | Specifies if the picklist option is managed (part of a managed solution). | |
| Label_LocalizedLabels | String | Localized labels for the picklist option in different languages. | |
| Label_UserLocalizedLabel_HasChanged | String | Indicates if the user-customized label for the picklist option has been modified. | |
| Label_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized label for the picklist option is managed. | |
| Label_UserLocalizedLabel_Label | String | The user-customized label text for the picklist option. | |
| Label_UserLocalizedLabel_LanguageCode | Integer | The language code corresponding to the user-customized label. | |
| Label_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-customized label. | |
| Description_LocalizedLabels | String | Localized descriptions for the picklist option in different languages. | |
| Description_UserLocalizedLabel_HasChanged | String | Indicates if the user-customized description for the picklist option has been modified. | |
| Description_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized description for the picklist option is managed. | |
| Description_UserLocalizedLabel_Label | String | The user-customized description text for the picklist option. | |
| Description_UserLocalizedLabel_LanguageCode | Integer | The language code corresponding to the user-customized description. | |
| Description_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-customized description. | |
| MetadataId | String | The unique identifier for the metadata associated with the picklist option. | |
| ParentValues | String | Specifies the parent values for hierarchical picklist options, if applicable. | |
| Value | Integer | The integer value associated with this picklist option, used for storage and retrieval. | |
| TableName | String | The name of the table where this picklist option is defined. |