Email mapping

Mapping allows you to map a collection of data values returned by the Experian Email Validation API to a collection of Microsoft Dynamics entity fields.

The pre-configured mappings that come with the solution (Address1 and Address2) are designed just for addresses out of the box but can optionally be utilized for mapping email data too, assuming the additional email data has been enabled and the fields created as detailed in the previous sections of this guide.

Configuring an email mapping

First select an existing mapping or add a new one:

1. Go to the Experian Data Validation Configuration Power App.
2. Select the Map fields page from the left menu.
3. From the entities list on the left select the entity for which you want to configure an address mapping.
4. Either select an existing mapping from the list in the MAPPINGS column or click + Add in the top menu to create a new mapping.
5. If adding a new mapping, select the Entity name, provide a Mapping name and then click Add.

The properties from our Email Validation API are found under the Email data fields tab, but will only appear if enabled on the Additional data page under the Email result or Email metadata sections.

The process for mapping the fields is as follows:

1. Under each API property is a combo box that contains the fields of the associated entity. Click on each combo box and select the field that you want populated with that API value. The list is separated into five types for convenience, depending on the data type of the field:
   • Text - the text value returned by the API is stored in the field.
   • Number - the integer or decimal value returned by the API is stored in the field. If the entity field only holds integers and a decimal value is returned by the API, the value will be truncated to an integer value.
   • DateTime - the date and time value returned by the API is stored in the field.
   • Choice - the item selected for the choice field will be the one where the text of the choice item matches the text returned by the API using a case insensitive match.
   • Lookup - the lookup record selected for the field will be the one where the text of the primary name column of the Lookup entity matches the text returned by the API using a case insensitive match.
2. For any standard or additional address data fields that you want to ignore, choose the value Not mapped from the combo box.

Additional form field configuration

If you have configured a mapping for additional email data as detailed above you will need to associate the mapping with the email field on the form.

1. Select Tables from the left hand menu of the main Power Apps interface.
2. Click the Table you want to configure.
3. Click Forms from the Data experiences panel at the top of table page.
4. Click the Form you want to configure (e.g. Account).
5. Select the email field you would like to configure.
6. Select the Properties tab in the panel on the right, scroll down to and expand the Components section.
7. Click the three dots icon next beside EDQEmail and click Edit.
8. Under Mapping name enter the name in the Static value text box. This would be Address1 or Address2 if you're using the mappings that come pre-configured with the solution. Otherwise enter the new mapping name you created above.

At this point, if you want to store the optional validation tracking values there are some extra steps:

9. Under Validation message choose the Table column created for the Email Validation message.
10. Under Validation timestamp choose the Table column created for the Email Validation timestamp.

Once all the steps have been completed click Done to close the component configuration panel and repeat for other email fields as required. Finally, click Save and publish in the command bar to commit your form changes.