PickListOptions
Defines the set of selectable options available for Picklist attributes, supporting user-defined field values.
View-Specific Information
Select
The connector 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 connector.
- TableName supports '=','IN' operators.
Note that without filtering on TableName, the connector returns the results for the first table found.
For example, the following queries are processed server side:
SELECT * FROM PickListOptions WHERE TableName = 'teams'
SELECT * FROM PickListOptions WHERE TableName IN ('accounts', 'teams')
Columns
| Name | Type | References | Description |
| ColumnName | String |
PickListAttributeMetaData.ColumnName | The name of the column in the table where the picklist option is defined. |
| Color | String | The color code associated with the picklist option, often used for display purposes in user interfaces. | |
| ExternalValue | String | An external value associated with this picklist option, used for integration with external systems. | |
| HasChanged | String | Indicates whether the picklist 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 multiple 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 (part of a managed solution). | |
| 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 associated with the user-customized label. | |
| Description_LocalizedLabels | String | Localized descriptions for the picklist option in various supported languages. | |
| Description_UserLocalizedLabel | String | The user-customized description for the picklist option, providing additional context or meaning. | |
| MetadataId | String | The unique identifier for the metadata associated with this 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. |