Share via

Migrating data from csv file to Dynamics 365 using ADF - Copy activity

Ann Jose (AU) 1 Reputation point
2022-02-14T01:15:34.887+00:00

I was trying to migrate data from csv files (stored in the azure blob storage) into Dynamics 365 (Account entity) using the copy activity. However, dynamics 365 lookup, picklist, Boolean, owner fields where not getting updated using the copy activity.

see the following mapping- all the source columns are in string type and sink data types are different. How to map the input string types properly?

173941-image.png

Here is the screenshot of one of the error messages - Kevin Martin is the primary contact value available in the csv file and which is in string format. In CRM, that field is a lookup to the contact entity. 173904-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,550 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2022-02-15T13:05:43.6+00:00

    Hi @Ann Jose (AU) ,

    Thank you for posting query in Microsoft Q&A Platform.

    From error message it looks like, ADF expecting GUID format as with 32 digits and 4 dashes but your source column doesn't have data in such format and ending up with conversion error.

    Kindly review your source data and confirm is that expected value to get pass in to sink.

    There is detailed guidance documented to follow while writing data to a lookup field. Click here to check same.

    Click here to know complete details about Dynamics 365 connector and all properties of it as source and sink.

    Please let us know how it goes. Thank you.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.