Posts

Showing posts from March, 2024

Duplicate Detection in Dynamics 365 using power apps.

Image
  User Case: When setting up a contact in Dynamics 365, verify if a contact with the same email address already exists. If it does, prompt an error message indicating a duplicate email address. Step 1 :  Navigate to make.powerapps.com, screen 1 à Create a Blank Canvas App à Connect with Dynamics 365 Data Source à Connect Contact Entity as Dataset (You can connect other entity also as per your requirement) Step 2:   Screen 2 - Insert a new Blank Screen to show Duplicate Detection Dialog Step 3:   Add few Text Input and Button Controls in Screen 1 or design as per your need. Step 4:  Add below formula on Button Control (onSelect property) to find Duplicate Record. If ( IsBlank ( LookUp ( Contacts , emailaddress1 = Emailaddress_Text . Text )), UpdateContext ({ result: "Duplicates Record not found" }), Navigate ( DuplicateDetectionDailogbox , ScreenTransition . CoverRight ) ) ; You can use following formula also on Button Control (onSelect property...