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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to add rule for a ...
Power Apps
Unanswered

How to add rule for a column to check if duplicate record present or not in Entity

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Joel CustomerEffective Profile Picture
    3,224 on at

    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.

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

Forum hierarchy changes are complete!

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…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 840 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 275

Last 30 days Overall leaderboard