Writing data to a lookup field via alternative keys

New Contributor

Hi Folks,


I have 2 table, 


1. Contact with a secondary key



2. Policyholder with a lookup field to contact and a column that contain the contact secondary key guid as a string




I want to take the column named : contactSecondaryKeyString in policyholder which contain the secondary key string(guid) and push it to my lookup field policyholder in the table policy holder.


As per microsoft it is possible : Copy and transform data in Dynamics 365 (Microsoft Dataverse) or Dynamics CRM - Azure Data Factory &...


Here is my mapping code : 




and I get the error : 


"ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=,Source=,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147217149, error message: 'prsc_phplan' entity doesn't contain attribute with Name = 'prsc_policyholder@prsc_systemid' and NameMapping = 'Logical'


I tried many variation and still can't figure it out...

1 Reply
No one has some ideas ?