Import into Dynamics 365 lookup column data using Azure Data Factory without GUID

Role Image

Hello Experts, 

Happy New Year!

I have a CSV file as source which has Account information. I need to import the Accounts from the CSV file into Dynamics 365 Account table. One of the column is Primary Contact Lookup in Account table. The source file does not have the Contact GUID to lookup in Dynamics but it has Primary Contact’s FullName and ContactNumber (custom column which is also available in Dynamics).

I am using Azure Data Factory to import into Dynamics365. When I do mapping in Copy Data, I don’t see an option to map the Primary Contact Lookup column using either FullName or ContactNumber. I remember in SSIS using KingswaySoft, we could map the Lookup using predefine keys or alt key. How do I handle this situation? Any help is highly appreciated.

Thank you,


Source link

Leave a reply

Please enter your comment!
Please enter your name here