Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

A duplicate lookup reference was found on important

(0) ShareShare
ReportReport
Posted on by 180


Hello,


I am importing child records for account but account ABC Corp exit twice in dynamics one in active and other is inactive 

I have added status column in excel with Active values.

 

on import i am choosing fields for related record type Account Name and Status.

But still getting 

A duplicate lookup reference was found.

 

Any suggestion ?

how to import child records for Active accounts ?

even if duplicate account is there which is inactive 

 

Thanks,

 

  • ChrisPiasecki Profile Picture
    6,389 Most Valuable Professional on at
    Re: A duplicate lookup reference was found on important

    Hi @Shafdev,

     

    To make sure you don't actually have any other duplicates, create a duplicate detection rule for Account based on account name and status. Then run a duplicate detection job.

     

    Also, are you using the classic import wizard? If so, you should be able to map the Account Lookup to the Account name and Status fields as shown below.

     

    CRMImport.PNG

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics