Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Answered

Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Posted on by 245

Hi,

I have an excel import template with data to import to a custom entity.

The excel import file contains a lookup field.

When importing the error is duplicate lookup field values.

When I check the lookup fields there is no duplicate values. I'm using a lookup text value (not guid)

What is the comparison used here. For example, I have a lookup list

400

400L

Are they considered duplicate when performing a data import?

  • RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

    Thank you for verifying the suggestions and solutions.  Welcome to the communities.

  • RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

    Oh boy, yes there is a duplicated inactive record. Thanks for that!

  • Verified answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,041 on at
    RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

    Hi,

    I will suggest you to recheck all the view for simply advanced find "new" to get all the data for Provider Group Code to make sure there is no duplication.

    Also have you checked if there is any inactive records for Provider Group Code which have 400R1.

  • RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

    Hi, thats what I used and followed to... but still encountering issue.

    Let me get you more detailed context.

    So I have custom entity called Benefit Plan Provider Group, at let's say it contains the following records

    Provider Group Code

    400R1

    400R10

    Now, I have a CSV file to import to another entity

    Benefit Rate ID    Provider Group Code Benefit Type

    400R1UHS1200    400R1                        Benefit

    400R1UHS2000    400R10                Benefit

    400R10DPAC808050   400R10                Benefit

    In the CSV, the field Provider Group Code is a lookup that mapped to the Provider Group entity.

    When I import the file here is the error

    "A duplicate lookup reference was found" for column 400R1

    Duplicate reference found for transformation output parameter mapped to: Benefit Plan Provider Group Code. Output Parameter Value: 400R1

    Hope you can help me on this.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

    Hi,

    I did quick test and it worked as expected on my crm instance

    I created Country entity and added below record in it.

    CQ42.PNG

    Then I added 2 record in csv file as shown below.

    CQ44.PNG

    As you can I am setting Country field value to 400 and 400L. I am creating Case record from import.

    CQ41.PNG

    And record imported successfully without issue.

    CQ43.PNG

    Please check error logs and provide screenshot to investigate your issue.

    Please mark my answer verified if i were helpful

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,041 on at
    RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

    Hi,

    No these won't be duplication, please make sure to check error log which particular column is showing as duplicate record.

    I hope you are already aware of this but in case you want to refer your lookup which present in the system as duplicate records, you have following two options

    1. Use some unique field instead of the lookup name to map lookup field.

    joshimandarblog.wordpress.com/.../

    2. Use GUID of the lookup record instead of the name field.

    Let me know if my understanding is not clear.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans