Power Platform Community Forum Thread Details

Hi Experts,

I have an entity (i.e Employee) where one field( i.e emp_id) is there which is having a unique value for each employee. When Admin User inserts a new record to the entity and while setting emp id we want a rule which will tell the user that the entered emp_id records are already present.

So, basically I want to know set a duplicate detection rule and when admin user insert a new record then they should get info that this emp_id is already available.

How can I set this rule?

Thanks,

Amit

Categories:

Microsoft Dataverse with Power Apps

Two options for you:

1. Create an alternate key with the employee id. This will prevent saving the record if that employee id is already taken https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/define-alternate-keys-entity

2. create a duplicate detection rule filtered off of employee id. This will prompt the user if someone has already used that employee id in a mode driven app https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean

if you really want to create a column and display if the employee is has been used before, you could have a power automate flow run on create or update of the employee I’d or in canvas app use a lookup formula to look for other records with the same employee I’d.