Tachytelic.net

This post covers using Loqate API to auto-fill address details in PowerApps. Manual entry of key customer and supplier details is error prone and time consuming.

The Loqate API is really simple, so you can develop a solution in a couple of minutes.

Watch the video for a demonstration of how I was able to develop a Power App that enables address search:

Address Lookup in PowerApps with Loqate

The app in the video uses two flows to get address information from Loqate.

The first flow uses the Interactive Find API method to get a list of possible address matches. Each result contains a unique ID which is used to drive the second flow.

The second flow uses the Retrieve API to get the details of the selected address from the first result set.

First Flow: Interactive Find

The flow is quite self explanatory. There are two inputs

• The country code.
• The search query.

These variables are inserted into the the query string and submitted to loqate using a HTTP action.

The interactive find returns a JSON array, which looks like this:

[
  {
    "Id": "GB|RM|A|53530442",
    "Type": "Address",
    "Text": "Microsoft, 2 Kingdom Street",
    "Highlight": "0-9;0-6",
    "Description": "London, W2 6BD"
  },
  {
    "Id": "GB|RM|A|55068353",
    "Type": "Address",
    "Text": "Microsoft Reactor, 70 Wilson Street",
    "Highlight": ";0-6",
    "Description": "London, EC2A 2DB"
  }
]

The Id column, which is highlighted above provides the input for the next flow.

The addresses are loaded into a collection which is used as the data source for the gallery of addresses:

ClearCollect(Addresses, TestAddressLookup.Run(txtAddressLookup.Text, dropCountry.Selected.Value))

Second Flow: loqate reteive

The second flow uses the Unique ID retrieved in the first flow to get all the details of the selected address:

Like the first flow, the results are stored in a collection, with the following code:

ClearCollect(AddressDetails, loqateRetrieve.Run(ThisItem.Id));
UpdateContext({searchVisible: false})

I used a context variable called “searchVisible” to set the visibility of the address lookup controls.

Back in the actual form I just set the default property of the dataCardValue text controls to:

First(AddressDetails).Company
First(AddressDetails).Line1
First(AddressDetails).Line2
etc

Download the flows to import into your environment here:

Flow 1 – Loqate Interactive Find
Flow 2 – Loqate Retieve

And that is how easy it is to add Address Lookup functionality in PowerApps! Any questions, just ask.