Announcements
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?
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)
So do i understand correctlyin 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?
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 KumarFollow my Blog: https://xrmdynamicscrm.wordpress.com/
Kudos and Accept my answer if helpful!
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
@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?
You can control when and where you want to apply your Duplicate Detection rule -
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 542 Most Valuable Professional
Haque 206
Kalathiya 201 Super User 2026 Season 1
