web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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,634

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

I have the same question (0)
  • Suggested answer
    Shidin Haridas Profile Picture
    Shidin Haridas 3,499 on at

    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.

  • Mohsin Ali Profile Picture
    Mohsin Ali 3,634 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans