Forum Discussion
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?
- 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.
