PickListAttributeMetaData
Holds metadata for attributes of type Picklist, describing the single-option selection fields in the system.
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 PickListAttributeMetaData WHERE TableName = 'teams'
SELECT * FROM PickListAttributeMetaData WHERE TableName IN ('accounts', 'teams')
Columns
| Name | Type | References | Description |
| ColumnName [KEY] | String | The name of the column in the table where the picklist attribute is defined. | |
| MetadataId | String | The unique identifier for the metadata associated with this attribute. | |
| OptionSet_Description_LocalizedLabels | String | Localized descriptions of the options in the picklist for various supported languages. | |
| OptionSet_Description_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized description label has been modified. | |
| OptionSet_Description_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized description label is managed (part of a managed solution). | |
| OptionSet_Description_UserLocalizedLabel_Label | String | The localized label text for the description of the picklist. | |
| OptionSet_Description_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-localized description label. | |
| OptionSet_Description_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-localized description label. | |
| OptionSet_DisplayName_LocalizedLabels | String | Localized display names for the picklist options in various languages. | |
| OptionSet_DisplayName_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized display name label has been modified. | |
| OptionSet_DisplayName_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized display name label is managed (part of a managed solution). | |
| OptionSet_DisplayName_UserLocalizedLabel_Label | String | The localized label text for the display name of the picklist. | |
| OptionSet_DisplayName_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-localized display name label. | |
| OptionSet_DisplayName_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-localized display name label. | |
| OptionSet_ExternalTypeName | String | The external type name associated with the option set, if applicable. | |
| OptionSet_HasChanged | String | Indicates if the option set has been modified since its creation or last update. | |
| OptionSet_IntroducedVersion | String | The version of the system in which the option set was introduced. | |
| OptionSet_IsCustomizable_CanBeChanged | Boolean | Indicates whether the option set can be customized by the user or administrators. | |
| OptionSet_IsCustomizable_ManagedPropertyLogicalName | String | The logical name of the managed property controlling customizability of the option set. | |
| OptionSet_IsCustomizable_Value | Boolean | Specifies if the option set is customizable. | |
| OptionSet_IsCustomOptionSet | Boolean | Indicates whether the option set is custom or part of a default configuration. | |
| OptionSet_IsGlobal | Boolean | Specifies if the option set is global (shared across entities) or local (specific to one entity). | |
| OptionSet_IsManaged | Boolean | Indicates if the option set is managed (part of a managed solution). | |
| OptionSet_MetadataId | String | The unique identifier for the metadata associated with the option set. | |
| OptionSet_Name | String | The name of the option set. | |
| OptionSet_OptionSetType | String | The type of the option set (e.g., picklist, drop-down). | |
| OptionSet_ParentOptionSetName | String | The name of the parent option set, if this option set is part of a hierarchy. | |
| TableName | String | The name of the table where the picklist attribute is defined. |