Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / "A duplicate look...
Microsoft Dynamics CRM (Archived)

"A duplicate lookup reference was found." with single record in CRM

(0) ShareShare
ReportReport
Posted on by Mohsin Ali 3,610

I've following list of fields in a CSV file to be imported in CRM. 

  1. Technical Proposal (Lookup to Custom Entity - Technical Proposal)

  2. Opportunity (Lookup to Opportunity )
  3. Opportunity ID (Text field - ID of Opportunity)
  4. Product Unit Cost (Currency Field)
  5. Quantity (Text Field)
  6. Costing Value (Currency Field)
  7. Selling Value (Currency Field)
  8. Outsourced? (Two options Field)

The CSV file contain only one record to be imported. Also, apart from Product lookup and Technical Proposal lookup, Opportunity lookup value is duplicated in CRM. But following walk-through; I've set the imported values for the opportunity lookup field. But still I am getting following two errors:

  1. A duplicate lookup reference was found. (For Product Column)
  2. The lookup reference could not be resolved. (For Opportunity Column)

https://dynamicscrmgirl.wordpress.com/2013/10/27/crm-2013-how-to-set-a-lookup-value-with-non-primary-field-as-reference-when-importing-csv-data/

*This post is locked for comments

  • Mohsin Ali Profile Picture
    Mohsin Ali 3,610 on at
    RE: "A duplicate lookup reference was found." with single record in CRM

    Shidin - I've only one product with this name in CRM, I've cross checked with OR Group for Status Reasons in Advanced Find. Also, yes I've two opportunities with same requirement but they have different Opportunity and by following the walkthrough (that you shared) But its not working.

    Also, all fields have unique display name on form

  • Suggested answer
    Shidin Haridas Profile Picture
    Shidin Haridas 3,497 on at
    RE: "A duplicate lookup reference was found." with single record in CRM

    1. A duplicate lookup reference was found. (For Product Column)

    This happens when you have multiple Product records with the same name. So, please ensure that there are no 2 products with the same name.~
    Since the data-import for lookups is based on the Name of the lookup record than the GUID, the system cannot, by itself, figrue out which record you mean to associate it to.
    See this for more details.

    2. The lookup reference could not be resolved. (For Opportunity Column)

    This is pretty straight-forward. There is no Opportunity in the system with the name you specified here. Can you please recheck if the Opportunity is present and of it is in Open State?

    PS: Also ensure that you are not importing any attribute columns which have similar display names.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans