Data Quality user documentation | Creating new fields

Looking to make configuration changes using the Classic interface?

Please view the documentation for our older v4.2 solution which details configuration using the Classic interface rather than Power Apps.

Additional data fields

If you configured any additional data in the previous section you will need to create new fields in your forms so that this data can be saved when it's returned from our APIs. For each data item you enabled repeat the process below:

Select Tables from the left hand menu of the main Power Apps interface.
Click the Table you want to configure (e.g. Account).
Click the Edit button at the top of the columns and data panel.
Click New column in the command bar.
Give your field an appropriate Display name and optional description.
Select appropriate options for the Data type and Format fields.
All other fields can be configured as per Microsoft's documentation if needed.
Click Save to save the new column.

Remember the field names

Make a note of these newly created field names as you'll need to know them when adding fields to a form and mapping fields in future sections.

Special fields

There are a handful of special fields which provide optional functionality that will give an extra level of detail on validated address, email and phone data. The creation of these is detailed below:

Configure this optional functionality to store the validation status and a timestamp together with the validated addresses, emails or phone numbers.

Select Tables from the left hand menu of the main Power Apps interface.
Click the Table you want to configure (e.g. Account).
Click the Edit button at the top of the columns and data panel.
Click New column in the command bar.
You need to create two fields for each validation type (address, email and/or phone). These fields are:
- Validation message
  - Click New column in the command bar.
  - Give your field a Display name e.g. Address validation message.
  - Select Single line of text for the Data type field.
  - Select Text for the Format field.
  - All other fields can be configured as per Microsoft's documentation if needed.
  - Click Save to save the new column.
- Validation timestamp
  - Click New column in the command bar.
  - Give your field a Display name e.g. Address validation timestamp.
  - Select Date and time for the Data type field.
  - Select Date and time for the Format field.
  - All other fields can be configured as per Microsoft's documentation if needed.
  - Click Save to save the new column.

Remember the field names

Make a note of these newly created field names as you'll need to know them when adding fields to a form and mapping fields in future sections.

You will need an Experian Phone Validation license to be able to use this feature.

Configure this optional functionality to include country calling codes in your form, as well as having the option to predefine the country code.

Select Tables from the left hand menu of the main Power Apps interface.
Click the Table you want to configure (e.g. Account).
Click the Edit button at the top of the columns and data panel.
Click New column in the command bar.
Give your field an appropriate Display name e.g. Country code.
Select Choice for the Data type field.
For the Sync with global choice? option choose Yes (recommended).
For the Sync this choice with option choose Country phone codes.
Select an appropriate Default choice.
All other fields can be configured as per Microsoft's documentation if needed.
Click Save to save the new column.

Remember the field name

Make a note of the newly created field name as you'll need to know it when adding fields to a form and mapping fields in future sections.

Was this helpful?

Next: Adding fields to a form

Microsoft D365 CE PCF

Create fields

Creating new fields
Adding fields to a form

Next topic:
Address mapping
Previous topic:
Data overview