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?
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 !
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156