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...
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.
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.