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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / avoiding duplicate rec...
Power Apps - Microsoft Dataverse
Answered

avoiding duplicate records in dataverse custom tables

(0) ShareShare
ReportReport
Posted on by julijazas 820

Hi

What is the scenario to avoid duplicates in dataverse custom tables using standart dataverse data entry?

I assume records will always be not duplicate as entering new record dataverse generates unique GUID.

Can you pls suggest what to do?

Categories:
Microsoft Dataverse
I have the same question (0)
  • Verified answer
    Guido Preite Profile Picture
    Guido Preite 1,488 Super User 2024 Season 1 on at
    Re: avoiding duplicate records in dataverse custom tables

    you can create an alternate key https://docs.microsoft.com/en-us/powerapps/developer/data-platform/define-alternate-keys-entity

    in this way the user is unable to create a duplicate based on the criteria defined by the key (for example two accunts can't have the same account number)

     

  • julijazas Profile Picture
    julijazas 820 on at
    Re: avoiding duplicate records in dataverse custom tables

    So do i understand correctly
    in my table i have a project name, Equipment name, Epmploye number, task name, task status

    If i define these columns as alternative keys - user will not be able to save same information?

  • Verified answer
    Bipin D365 Profile Picture
    Bipin D365 971 on at
    Re: avoiding duplicate records in dataverse custom tables

    Hi @jja ,

     

    You can also setup Duplicate detection rule in your instance to prevent creating duplicate records in yoru system.

     

    https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean

     

    Regards,

    Bipin Kumar
    Follow my Blog: https://xrmdynamicscrm.wordpress.com/

    Kudos and Accept my answer if helpful!

  • Guido Preite Profile Picture
    Guido Preite 1,488 Super User 2024 Season 1 on at
    Re: avoiding duplicate records in dataverse custom tables

    correct, you can also combine different columns in the same key (when you create the key it will show only the available columns because not all the types can be used) and the system will stop the user to create a new record with the same key

  • julijazas Profile Picture
    julijazas 820 on at
    Re: avoiding duplicate records in dataverse custom tables

    @bipinshan 

    Does this duplicate detection rule also prevent from entering into system or you can afterwards run some report to get all the duplicate records and then delete manualy ir set a job to be it deleted/merged?

  • Bipin D365 Profile Picture
    Bipin D365 971 on at
    Re: avoiding duplicate records in dataverse custom tables

    Hi @jja ,

     

    You can control when and where you want to apply your Duplicate Detection rule -

    bipinshan_0-1643625097349.png

     

    Regards,

    Bipin Kumar
    Follow my Blog: https://xrmdynamicscrm.wordpress.com/

    Kudos and Accept my answer if helpful!

  • julijazas Profile Picture
    julijazas 820 on at
    Re: avoiding duplicate records in dataverse custom tables

    Hi @GuidoPreite @bipinshan 
    Both scenarios fit for me but i see i will have an issue let me describe:

    in a table Components i store Project name, Component name, Component qty

    In table Transactions i register what was done with the certain component so it looks liek this

    Project name:Project1

    Component name: A001

    Component qty:1

    Status: completed

     

    But it might happen that i have the total qty of Component name A001 2psc

    then if user registers the completed qty in separate records 1 by 1 this A001 and i enable duplicate detection rule it will not allow him to enter this another missing 1 psc from total 2

    What would you suggest in this case?

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes happening today, December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans