Migration of dynamics on prem Data Into Dynamics cloud (parentcustomerid Field)

(0) Share

Report

Posted on by McDauly

219

Hello we are trying to migrate our crm 365 on prem to the cloud version. I already installed the solutions and now I try to Migrate the data via powerapps dataflow. I connected the sql database and already managed to migrate the first easy tables.

Now I have the problem that I cannot fill the parentcustomerid field. I know its a special field because it can hold mutiple entities.
I also tried to solve my problem with this guide

https://community.dynamics.com/365/b/crm-keeper/posts/dataflows-customer-lookup-fix

But I dont see the dataflow on that page:

https://admin.powerplatform.microsoft.com/ext/DataIntegration/

end also the given link leads me to nowhere..

The only solution I can think of is to make a new relation and make a new field in the contact table to save the relation there and afterwards let a flow copy it into parentcustomerid.
But I guess this is not a good solution because I will meet that issue in several more tables..

Anyone know how I can overcome this problem?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hello McDauly,

Please refer to the following blog: https://crmkeeper.com/2020/03/10/data-flow-set-customer-lookup/

Basically, you need to use some alternate keys..Good Luck !

Was this reply helpful? Yes No