DQ for Dynamics™ Cleanse has been developed to provide continuous data cleansing for Dynamics 365 users with an easy-to-use bulk data cleansing tool. Removing the time-consuming task of ongoing CRM data cleansing.

You can bulk cleanse, validate, and verify your: email, phone, and address fields with easy-to-use power automate data cleansing workflows. Working right inside Dynamics 365 to make cleansing your CRM records a simple task, helping to increase user adoption and deliver trusted Customer Data.

This is a step-by-step user guide to help you download, install, and configure the latest DQ Cleanse solution for Microsoft Dynamics CRM.

Note: Please ensure you have the necessary permissions to access Customization within Dynamics 365 Advanced Settings.

1. Firstly, download the following:

In order to install and use the cleanse solutions, you must first register with DQ Global which can be done here. After registering, DQ Global will provide you with an API key and a unique password via email.

By registering you will automatically start a 14-day free trial and will have 1,000 free credits for to trial the services we offer.

To use the Cleanse flows past your trial you will need to first buy credits from the DQ Shop here. After logging in, this will take you to the DQ Shop. To buy credits, choose Add to basket on one of the Credit Packs. From here, follow the instructions on screen to purchase your credits.

NOTE: You may have been provided a key by DQ Global, if this is the case, please skip this step.

Head to the PowerApps maker portal (https://make.powerapps.com).

Select the environment you will be installing into.

From here, select Solutions on the left-hand navigation bar.

Now select Import Solution from the top navigation bar.

Select Choose file, select the file, then select Next.

Setup your Connections, then select Import.

After all of the solutions have been successfully imported, select Publish All Customizations.

This step is only applicable if you have less than 250k records.

If you have more than 250K rows it will still function but please reach out to support@dqglobal.com as we have faster onboarding methods for larger customers.

Head to the PowerApps maker portal (https://make.powerapps.com).

Select the environment you will be installing into.

From here, select Flows on the left-hand navigation bar.

In the top-right enter onboard into the search box. And then press the run button on all of the flows

Once the Cleanse solutions have been installed you don't have to do anything to use them, the flows will monitor changes to your data and will queue the changes to be checked. Every 8 hours the queued changes will be checked and the results are written back to the relevant tables.

The results can be seen in 3 ways

1) You can use the Cleanse Dashboards (https:<EnvironmentURL>/main.aspx?pagetype=dashboard&etn=<dqg_email | dqg_phone | dqg_address>) 2) You can look at the Cleanse Tables (https:<EnvironmentURL>/main.aspx?pagetype=entitylist&etn=<dqg_email | dqg_phone | dqg_address>)

3) You can look at the records associated with a record