How to Modify Duplicate Detection Job Results View with the Power Platform
When an Administrator configures and enables Duplicate Detection Rules in your system, it will prompt end users who create or modify a record that results in a potential duplicate based on the rules in place.
The user can then merge the duplicate records or ignore and close the message.
System Administrators can also run Duplicate Detection Jobs to check for potential duplicate records in bulk. This job is purposely run from the Power Platform Admin Center and is not triggered by any creation or modification of individual records. You can also run the jobs on-demand, scheduled, or scheduled and set as recurring.
Pros and Cons of Using the Power Platform for Duplicate Detection
When you run a Duplicate Detection job from the Power Platform Admin Center, you will see a long list of job results on the screen and one potential duplicate at a time. You can then manually analyze the results and consider what steps to take to solve the problem. The issue with this method is investigating each potential duplicate on the list can be very time-consuming and tedious. If you look at the results view though, it contains columns of data that can help you compare two records immediately. This prevents you from having to open each potential duplicate record in a new window.
There are instances, however, where the results view does not contain the data columns you require to compare duplicate records. While it can be tricky to find this view, you can still do so and modify it.
How to Modify the Duplicate Detection Job Results View
First, let us understand how the out-of-box Duplicate Detection Job results view is compiled. This is a sample of the Contact Duplicate Detection Job result view columns:
It displays columns from three sources:
- Microsoft hard codes the first three columns of the view to include Name, Status, and Modified On.
- Additional columns are added to represent all fields that have been defined as Duplicate Detection Rule Criteria.
- Columns from the Contacts Lookup View are added if they are not already included in the first two sources.
You can add columns to, or remove columns from, the system Lookup View for the relative table to create a more meaningful view. This may eliminate the need to open each potential duplicate record to determine if it is a duplicate or not.
Want to Learn More About Capabilities Inside the Power Platform?
Get in touch with the team at Stoneridge Software! Our experts can help you learn more about the Power Platform and how it can help you improve your business by automating tasks and simplifying workflows.
Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.
Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.