Excel Add-In for Dynamics 365

Build 21.0.8137


Contains the Options Value of MultiSelect PicklistMetadata. Note: This view is only available when Edition is set to either CustomerService, FieldService, Marketing, ProjectOperations or Sales.


The add-in will use the Dynamics 365 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.

For example, the following queries are processed server side:

SELECT * FROM MultiSelectPickListOptions where TableName = 'teams'

SELECT * FROM MultiSelectPickListOptions where TableName IN ('accounts','teams')


Name Type Description
ColumnName String
Color String
ExternalValue String
HasChanged String
IsManaged Boolean
Label_LocalizedLabels_HasChanged String
Label_LocalizedLabels_IsManaged Boolean
Label_LocalizedLabels_Label String
Label_LocalizedLabels_LanguageCode Integer
Label_LocalizedLabels_MetadataId String
Label_UserLocalizedLabel_HasChanged String
Label_UserLocalizedLabel_IsManaged Boolean
Label_UserLocalizedLabel_Label String
Label_UserLocalizedLabel_LanguageCode Integer
Label_UserLocalizedLabel_MetadataId String
Description_LocalizedLabels_HasChanged String
Description_LocalizedLabels_IsManaged Boolean
Description_LocalizedLabels_Label String
Description_LocalizedLabels_LanguageCode Integer
Description_LocalizedLabels_MetadataId String
Description_UserLocalizedLabel_HasChanged String
Description_UserLocalizedLabel_IsManaged Boolean
Description_UserLocalizedLabel_Label String
Description_UserLocalizedLabel_LanguageCode Integer
Description_UserLocalizedLabel_MetadataId String
MetadataId String
ParentValues String
Value Integer
TableName String

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137