Excel Add-In for Microsoft Dataverse

Build 25.0.9434

MultiSelectPickListAttributeMetaData

Stores metadata for attributes that support MultiSelect OptionSet, defining the structure and behavior of multi-option fields.

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 MultiSelectPickListAttributeMetaData WHERE TableName = 'teams'

SELECT * FROM MultiSelectPickListAttributeMetaData WHERE TableName IN ('accounts', 'teams')

Columns

Name Type References Description
ColumnName [KEY] String The name of the column in the table where the multi-select picklist 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 different languages.
OptionSet_Description_UserLocalizedLabel_HasChanged String Indicates whether the user-localized description label has been modified.
OptionSet_Description_UserLocalizedLabel_IsManaged Boolean Specifies if the user-localized description label is managed (part of a managed solution).
OptionSet_Description_UserLocalizedLabel_Label String The localized label text for the option set description.
OptionSet_Description_UserLocalizedLabel_LanguageCode Integer The language code corresponding to the localized description label.
OptionSet_Description_UserLocalizedLabel_MetadataId String The unique identifier for the metadata associated with the localized description label.
OptionSet_DisplayName_LocalizedLabels String Localized display names of the picklist options for different languages.
OptionSet_DisplayName_UserLocalizedLabel_HasChanged String Indicates whether the user-localized display name label has been modified.
OptionSet_DisplayName_UserLocalizedLabel_IsManaged Boolean Specifies if the user-localized display name label is managed (part of a managed solution).
OptionSet_DisplayName_UserLocalizedLabel_Label String The localized label text for the option set display name.
OptionSet_DisplayName_UserLocalizedLabel_LanguageCode Integer The language code corresponding to the localized display name label.
OptionSet_DisplayName_UserLocalizedLabel_MetadataId String The unique identifier for the metadata associated with the 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.
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.
OptionSet_IsCustomizable_ManagedPropertyLogicalName String The logical name of the managed property that controls the 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 managed solution.
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, multi-select).
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 this multi-select picklist attribute is defined.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434