Configure Melissa Express Entry Autocomplete on Dataverse Forms

Modified on Fri, 14 Mar at 4:26 PM

This article covers how to setup the Address Validation Melissa Express Entry Autocomplete Control on Microsoft Dataverse Model Driven forms. These steps must be done by an administrator or a user with system configuration privileges.


TABLE OF CONTENTS


Configure Express Entry Autocomplete on Model Driven Forms


Considerations for this article

To make the documentation simple, we have chosen to use the Account table with the "Address 1" columns as an example. The configuration is similar of other tables and columns, out of the box or custom.
    
  • In the Power Apps Maker Portal, find the solution containing the entities and forms for which you want to configure Melissa Express Entry Autocomplete control. 
  • Open the Account table, and find the form you want to use Address Autocomplete on
  • Open the form you want to edit and click on “Switch to classic” in the command bar
  • In the classic configuration screen, add the Address Street Line 1 of the form and click on Change Properties in the ribbon to access the Field Properties screen.
  • In the “Display” area, uncheck the “Display label on form” checkbox
  • Next go the Controls Tab and add the control named "Melissa Data Express Entry Autocomplete" and select the devices where you want the control to be displayed. 

  • Once you have selected the control, you need to provide a value for required properties (identified with a * in the table below); all the other properties are not mandatory :

PropertyDescriptionField Type
API Configuration Name *This refers to your API Configuration unique record name.Static Text Value
Advanced Setting IDIf you are using Advanced Control Settings, you need to put the Identifier of your Advance Setting record here.Static Text Value
Display Address FieldsThe control can display the address fields under the address search control. Set the value to YES to display these fields. This is a legacy feature.

We recommend setting the value to NO and displaying individual address fields yourself. 
Single Line of Text
Delivery AddressThe first line of the delivery address returned.
Single Line of Text
BuildingThe name of the building attached to the address
Single Line of Text
Sub BuildingThe subdivided information within a single premise like suite or apartment. 
Single Line of Text
OrganizationThe organization at the address (where available)
Single Line of Text
Locality * The most common area value, also known as City or Canton.Single Line of Text
Dependent Locality
The area smaller than locality (if necessary for the mailing address)
Single Line of Text
Administrative Area* The Administrative Area of the address returned, also known as State or Province.
Single Line of Text
Postal CodeThe full postal code, also known as Zipcode.

Note : Melissa Express Entry returns the extended zip codes in the USA by default (commonly referred to as zip+4). See the Advanced Control Settings section if you need to disable this features.
Single Line of Text
Country * The country of the output address in the format configured by the user. 

Note : the country is defaulted to its long name. If you want an ISO2 or ISO3 format, see the Advanced Control Settings section. 
Single Line of Text
SubAdmin AreaThe SubAdministrative area of the address returned, also known as County.
Single Line of Text
Full addressColumn where you want to store the fully formatted address as a single line of text. Leave empty is you do not need this.Single Line of Text
LatitudeThe latitude of the output address.Floating Point Number
LongitudeThe longitude of the output address.
Floating Point Number
Default CountryWhen the form is loaded, this country will be selected by default. Enter one country's ISO 3166-1 alpha-2 code (i.e. US, CA, MX, etc.) 
Static Text Value
Display CountriesList of countries that will be available in the user interface for selection.

Type the countries using their ISO 3166-1 alpha-2 code (i.e. US, CA, MX, etc.). To display more than one country, type them by separating them with a comma "," without blank spaces (i.e. US,CA,MX).

Static Text Value
Top CountriesThese countries will be pinned to the top of the list (most frequently used countries).

Type the countries using their ISO 3166-1 alpha-2 code (i.e. US, CA, MX, etc.). To display more than one country, type them by separating them with a comma "," without blank spaces (i.e. US,CA,MX).


  • To set a 'Default Country' or 'Top Country', it must first be added in the ‘Display Countries’ property as well.
  • If a country is saved on the address column (by a background process) and it is not configured in the 'Display Countries' property, the data will be saved, but it will no appear in the address control.
Static Text Value

  • Click OK, save the form and publish it.
  • Open your account and test your control


Configuration steps using the Maker Portal (step by step)



Working with Advanced Settings


Advanced Control Settings allow administrators to configure additional parameters for the address autocomplete control. These parameters are useful for organizations that require their state or provinces to be captured in a specific format. For example, if ISO2 country codes are required, it can be specified in the advanced settings. 


  • To get started, find the Advanced Settings by navigating to the Address Validation for Power Apps application and select the “Address Control Settings” menu. Click + New to create a new record.

  • Set the required values 
    • Identifier : Unique Identifier of the Setting. This will be used in the control's configuration on the form. 
    • API Type : Select Melissa
  • List of parameters available for Melissa :
ParameterPossible ValuesDescription
Return PO BoxesYes / NoUS Only. Enables autocomplete control to return PO Boxes along with addresses. 

By default, it is set to Yes (i.e. if no setting is present, PO Boxes are returned by Express Entry)
Include Extended Postal CodeYes / NoAllows to add the +4 section of the zip code when available.  

By default, it is set to Yes (i.e. if no setting is present, extended postal codes are returned by Express Entry) 
Country DisplayUse ISO2 Country Code
Use ISO3 Country Code ***
Use Long Country Name
--> CA
--> CAN
--> Canada
  • Advanced Setting Screenshot   

Important Note : these parameters are saved on your end-users' local cache. If you make changes to them, they will need to clear their browser cache for them to be reflected in their usage of Express Entry autocomplete in Dataverse.



Visual Example in a Model Driven Form


Assign the required security privileges to users


Once the configuration is completed, you need to assign the required security roles to your end users to allow them to use the autocomplete controls. Refer to this article for details on how to achieve this.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article