Combining the power of Data8 Duplicare™ with the versatility of Power Automate can give some amazing ways of handling duplicate data within your Dataverse environment.

During this blog post, we will use the scenario we see most often – which is fixing duplicate contacts just after they are created. There are several platforms out there, one example being Click Dimensions, that will take a form posted from a website and only do some basic checking such as “does the email exist?” and upon failure of that, it will create a contact with very little information. This is undesirable in a world where data is king – so our scenario here is: “Fixing duplicates created by Click Dimensions”.

Click Dimensions, like many other platforms, will do its thing and create records. We can’t hook into any earlier steps to prevent that, so we have to go for the next best alternative – try to sort out the potentially duplicate contact almost immediately after it was created and this is where we can really leverage the power of Power Automate using the “When a row is added, modified or deleted” Dataverse action.

Furthermore, if we don’t want to run this for all leads created, we can filter it further. Many usages of Click Dimensions create the lead with a specific source campaign – so that’s one way we can decide to run this only on those rows.