Look up filed issue via powerautomate

(3) Share

Report

Posted on by Honey98

174

Hi Team,

I'm facing one issue with the data migration from salesforce to Dataverse via power automate. now what is happening is if salesforce have 1 account and in that one account 5 contacts then in Dataverse it will create 5 records for that account because the data type of contact is lookup, and we need to migrate the data from salesforce to Dataverse through power automate and we cannot delete the data existing data verse. and it creates duplicate records in Dataverse. help me out how I can migrate the lookup filed without creating duplicate fields in Dataverse. considering that we cannot delete the data from Dataverse once its migrated.

Categories:

Power Platform integration

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

First, migrate Contacts to Accounts and check for existing records in Dataverse using the Salesforce Account ID. Then, migrate Contacts and ensure each Contact is linked to the correct Account using the Account Lookup field. Use alternate keys in Dataverse to enforce uniqueness and prevent duplicates. Finally, test the migration with a small data set before executing the full migration to avoid issues.

https://community.dynamics.com/blogs/post/?postid=5ab2a8a6-d979-47b9-9337-819dd9171a3b

Thanks, Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No