You can use a data pattern rule on a Dataverse table to validate if a field value matches a defined pattern.

To set up a data pattern rule, first set up the data pattern to be applied. Define the data pattern, using a regular expression.

You can, for example, set up data patterns to validate:

• Email addresses
• Website URLs
• VAT numbers

For more information on regular expressions, refer to Regular expression.

Standard procedure

1.	Sign in to Data quality studio on Dataverse.
2.	In the Site map, click Data Patterns.
3.	Click New.
4.	In the Name field, enter a descriptive name for the data pattern.
5.	In the Data Pattern field, enter a regular expression that defines the data pattern.
6.	In the Error Message field, enter the message that is shown when validation fails to match the data pattern.
7.	When you create a data pattern, by default, your user account is assigned as the owner. You can assign another user account as owner.
	In the Owner field, if desired, you can make changes.
8.	Subtask: Test data pattern.
8.1	You can test the created data pattern to verify if it gives the desired results.
	In the test Cases section, click New Test Case.
8.2	In the Input field, enter a test value.
8.3	In the Expected Result field, indicate if you expect the input value to fail or past the test.
8.4	Click Save & Close.
	Note: The test is automatically done. In the Test Cases section, you can compare the actual result with the expected result.