Forum Discussion

blevels's avatar
blevels
Copper Contributor
Aug 04, 2023

ADF Pipline CopyData SQL Server to Dynamics 365 Lookup

Can someone share the JSON from a working example of ADF pipeline that updates a D365 Lookup.
I find it easier to learn by example rather than discuss the error message received. 

 

What should be the mapping?  How should the entity reference columns be formed? 

1 Reply

  • blevels's avatar
    blevels
    Copper Contributor
    Aug 08, 2023
    MS Learn Documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory#writing-data-to-a-lookup-field

    However, the expression here in the MS Learn doc is misleading.

    The expression should be in this format: expression '/EntityReference('+ lookup_field_name+')'
    Here the EntityReference should be the PLURAL form of the lookup table. This is very important.
    Secondly the lookup_field_name should be the GUID reference to the lookup table.

Resources