title
description
ms.date
ms.service
ms.topic
ms.assetid
author
ms.author
search.audienceType
List Value Mapping (PickListMapping) table/entity reference (Microsoft Dataverse) | Microsoft Docs
Includes schema information and supported messages for the List Value Mapping (PickListMapping) table/entity.
06/04/2024
powerapps
reference
3948cc48-07c8-7f60-0608-71c37158ad7c
phecke
pehecke
List Value Mapping (PickListMapping) table/entity reference
In a data map, maps list values from the source file to Microsoft Dynamics 365.
Message
Web API Operation
SDK class or method
Create
POST /picklistmappings See Create
xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create*
Delete
DELETE /picklistmappings(picklistmappingid ) See Delete
xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete*
Retrieve
GET /picklistmappings(picklistmappingid ) See Retrieve
xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve*
RetrieveMultiple
GET /picklistmappings See Query Data
xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple*
Property
Value
CollectionSchemaName
PickListMappings
DisplayCollectionName
List Value Mappings
DisplayName
List Value Mapping
EntitySetName
picklistmappings
IsBPFEntity
False
LogicalCollectionName
picklistmappings
LogicalName
picklistmapping
OwnershipType
None
PrimaryIdAttribute
picklistmappingid
PrimaryNameAttribute
SchemaName
PickListMapping
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName .
Property
Value
Description
Unique identifier of the column mapping with which this list value mapping is associated.
DisplayName
Column Mapping Id
IsValidForForm
True
IsValidForRead
True
LogicalName
columnmappingid
RequiredLevel
ApplicationRequired
Targets
columnmapping
Type
Lookup
Property
Value
Description
Version in which the component is introduced.
DisplayName
Introduced Version
FormatName
VersionNumber
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
introducedversion
MaxLength
48
RequiredLevel
None
Type
String
Property
Value
Description
Unique identifier of the picklist mapping.
DisplayName
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
picklistmappingid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
Property
Value
Description
Information about whether the list value mapping needs to be processed.
DisplayName
Process Code
IsValidForForm
True
IsValidForRead
True
LogicalName
processcode
RequiredLevel
SystemRequired
Type
Picklist
ProcessCode Choices/Options
Value
Label
Description
1
Process
2
Ignore
3
Internal
4
Unmapped
Property
Value
Description
Source value to be replaced.
DisplayName
Source Value
FormatName
Text
IsLocalizable
False
IsValidForForm
True
IsValidForRead
True
LogicalName
sourcevalue
MaxLength
2097152
RequiredLevel
None
Type
String
Property
Value
Description
Reason for the status of the picklist mapping.
DisplayName
Status Reason
IsValidForForm
True
IsValidForRead
True
LogicalName
statuscode
RequiredLevel
SystemRequired
Type
Status
StatusCode Choices/Options
Value
Label
State
0
Active
0
Property
Value
Description
Microsoft Dynamics 365 list value with which to replace the source value.
DisplayName
Target Value
Format
None
IsValidForForm
True
IsValidForRead
True
LogicalName
targetvalue
MaxValue
2147483647
MinValue
-2147483648
RequiredLevel
None
Type
Integer
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate . Listed by SchemaName .
Property
Value
Description
Name of the column mapping.
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
columnmappingidname
MaxLength
100
RequiredLevel
SystemRequired
Type
String
Property
Value
Description
For internal use only.
DisplayName
Component State
IsValidForForm
False
IsValidForRead
True
LogicalName
componentstate
RequiredLevel
SystemRequired
Type
Picklist
ComponentState Choices/Options
Value
Label
Description
0
Published
1
Unpublished
2
Deleted
3
Deleted Unpublished
Property
Value
Description
Unique identifier of the user who created the list value mapping.
DisplayName
Created By
IsValidForForm
False
IsValidForRead
True
LogicalName
createdby
RequiredLevel
None
Targets
systemuser
Type
Lookup
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdbyname
MaxLength
100
RequiredLevel
None
Type
String
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdbyyominame
MaxLength
100
RequiredLevel
None
Type
String
Property
Value
DateTimeBehavior
UserLocal
Description
Date and time when the list value mapping was created.
DisplayName
Format
DateAndTime
IsValidForForm
False
IsValidForRead
True
LogicalName
createdon
RequiredLevel
SystemRequired
Type
DateTime
Property
Value
Description
Unique identifier of the delegate user who created the picklistmapping.
DisplayName
Created By (Delegate)
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfby
RequiredLevel
None
Targets
systemuser
Type
Lookup
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfbyname
MaxLength
100
RequiredLevel
None
Type
String
CreatedOnBehalfByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfbyyominame
MaxLength
100
RequiredLevel
None
Type
String
Property
Value
Description
Information that specifies whether this component is managed.
DisplayName
State
IsValidForForm
False
IsValidForRead
True
LogicalName
ismanaged
RequiredLevel
SystemRequired
Type
Boolean
IsManaged Choices/Options
Value
Label
Description
1
Managed
0
Unmanaged
DefaultValue : 0
Property
Value
Description
Unique identifier of the user who last modified the list value mapping.
DisplayName
Modified By
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedby
RequiredLevel
None
Targets
systemuser
Type
Lookup
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedbyname
MaxLength
100
RequiredLevel
None
Type
String
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedbyyominame
MaxLength
100
RequiredLevel
None
Type
String
Property
Value
DateTimeBehavior
UserLocal
Description
Date and time when the list value mapping was last modified.
DisplayName
Modified On
Format
DateAndTime
IsValidForForm
True
IsValidForRead
True
LogicalName
modifiedon
RequiredLevel
SystemRequired
Type
DateTime
Property
Value
Description
Unique identifier of the delegate user who last modified the picklistmapping.
DisplayName
Modified By (Delegate)
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfby
RequiredLevel
None
Targets
systemuser
Type
Lookup
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfbyname
MaxLength
100
RequiredLevel
None
Type
String
ModifiedOnBehalfByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfbyyominame
MaxLength
100
RequiredLevel
None
Type
String
Property
Value
DateTimeBehavior
UserLocal
Description
For internal use only.
DisplayName
Record Overwrite Time
Format
DateOnly
IsValidForForm
False
IsValidForRead
True
LogicalName
overwritetime
RequiredLevel
SystemRequired
Type
DateTime
Property
Value
Description
Unique identifier of the Pick List Mapping.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
picklistmappingidunique
RequiredLevel
SystemRequired
Type
Uniqueidentifier
Property
Value
Description
Unique identifier of the associated solution.
DisplayName
Solution
IsValidForForm
False
IsValidForRead
True
LogicalName
solutionid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
Property
Value
Description
Status of the picklist mapping.
DisplayName
Status
IsValidForForm
True
IsValidForRead
True
LogicalName
statecode
RequiredLevel
SystemRequired
Type
State
StateCode Choices/Options
Value
Label
DefaultStatus
InvariantName
0
Active
0
Active
Property
Value
Description
For internal use only.
DisplayName
Solution
IsValidForForm
False
IsValidForRead
False
LogicalName
supportingsolutionid
RequiredLevel
None
Type
Uniqueidentifier
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName .
lk_picklistmapping_modifiedonbehalfby
See the lk_picklistmapping_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
PickListMapping_ColumnMapping
See the PickListMapping_ColumnMapping one-to-many relationship for the columnmapping table/entity.
lk_picklistmapping_createdby
See the lk_picklistmapping_createdby one-to-many relationship for the systemuser table/entity.
lk_picklistmapping_createdonbehalfby
See the lk_picklistmapping_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_picklistmapping_modifiedby
See the lk_picklistmapping_modifiedby one-to-many relationship for the systemuser table/entity.
Dataverse table/entity reference
Web API Reference