MultiSelectPickListOptions
Contains the possible selectable options for MultiSelect OptionSet attributes, enabling multi-value selections.
View-Specific Information
Select
The add-in 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 add-in.
- TableName supports '=','IN' operators.
Note that without filtering on TableName, the add-in 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. |