Data Validation Tool

This XrmToolBox tool allows you to validate if the column values comply with the column metadata and some built-in string formats (developed by Matt Beard).

If there is a metadata change (e.g. reducing the max length of a text column, reducing the min/max value range of a whole number column, removing the items from the choice column, etc.), the existing data remains the same even though the system no longer accepts new data that exceeds the range. Those existing data with invalid data cause the problem when the Data Export Service is configured and it tries to sync those data.

To avoid Data Export Service sync failure rows, you can use this tool to validate the existing data against the metadata before setting up the Data Export Service.

• Tool Information
• Blog Post 1, Blog Post 2
• Functionalities
• Validate the data against the column metadata and some built-in string formats (Fig. 1, Pt. 3)
• Select the table to validate the data (Fig. 1, Pt. 2)
• Enter the validation tests for the columns to be validated (Fig. 1, Pt. 2)
• Validate with the column metadata (Fig. 2, Pt. 1)
• Validate the string format (Fig. 2, Pt. 2)
• Apply the selected validation setting to all columns (Fig. 2, Pt. 3)
• View the list of rows that failed the validation (Fig. 1, Pt. 4)

Fig. 1 - Data Validation Tool

Fig. 2 - Validation Options

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.