40
Hi,
I have problem to update around 900 Account records to update only one custom lookup field. The reference record in the looked up entity is already created and existing.
They all throwing the errors:
I tried to manually update some account records with the same value for the lookup field I want to import, no issue.
Thanks for the reply.
Yes, the 99% of the failures were the error message regarding the duplicate lookup.
My issue is that,
So we have for example 100 payment term records, with the same "Name" in Payment term entity.
If someone else updates the record you're trying to import between the moment you exported the list and you import the updated list, you get the first error. Avoid this by doing your update as fast as possible and when the least people are using Dynamics.
If you try to update a lookup field that exists multiple times with the same name, you'll get the second error. Make sure the lookup records have different names before you import the records. Otherwise look for an unique identifier field for the lookup record and use that field instead for the name of the look up to import the records.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (