Bulk Address Verifier and Geocoder

This XrmToolBox tool allows you to verify and geocode the address stored in the columns of the Microsoft Dataverse tables using Bing Maps API (developed by Salim Adamon and Sebastien Bernard).

When the address data is entered manually or imported from another system, the data is may not be standardised and accurate.

To verify and geocode all address data of the system in bulk, you can use this tool to select the table, specify the address columns and update with the standardised address from the Bing Maps API.

• Tool Information
• Blog Post
• Functionalities
• Validate the address data (Fig. 1, Pt. 3)
• Enter the Bing Maps API key (Fig. 1, Pt. 4)
• Retrieve the list of tables from the system (Fig. 1, Pt. 1) and select the one with the address to validate and geocode (Fig. 1, Pt. 5)
• Select the system or personal view that will return the rows to run the address verification and geocoding on (Fig. 1, Pt. 6)
• Select the source columns of the address (Fig. 1, Pt. 7)
• Copy the source column names into the destination column name if the validated values will be updated to the same fields (Fig. 1, Pt. 2)
• Select the destination columns to which the values from the Bing Maps API values will be updated (Fig. 1, Pt. 8)
• Select Longitude and Latitude columns to store the geocode (Fig. 1, Pt. 8)
• Select the column to store the validation status (Fig. 1, Pt. 8)
• Additionally, the tool can
• Show the output log of the address verification process (Fig. 1, Pt. 11)

Fig. 1 - Bulk Address Verifier and Geocoder

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.