Answered

Searching a list of locations and displaying the nearest (UK postcode)

(0) Share

Report

Posted on by RobPL

I've got a list of 300+ locations that I would like to allow a user to search by entering their postcode and then the app displaying the results by nearest first.

I've got the first few steps sorted, and an output into a gallery which automatically goes to alphabetical order based on the location name. This shows up fine, along with the miles to each location from the entered postcode.

However when I try to organise it by mileage I get the error "one or more locations specified in the waypoint parameter are invalid or require more information"

I'm using

SortByColumns(SiteDistance,"Miles",SortOrder.Ascending)

for the gallery and a button with the OnSelect function below to populate the collection "SiteDistance"

ClearCollect(SiteList,Directory);

ClearCollect(SiteDistance, AddColumns(SiteList, "Miles", Value(Round(BingMaps.GetRouteV2(TextInput1.Text,postcode,{distanceUnit:"Mile"}).travelDistance,0))))

I'm fairly new to this so learning as I go, I'd appreciate some guidance on what's missing, and why it works when there's no sorting, but the error happens when I try and sort it by nearest first.

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

RobPL 15 on at

Like (0)

Report
Copy link

Link copied!

A bit more digging and I found a couple of postcodes that didn't return a result. In the initial results, it returned a blank distance, but when I tried to order them by distance, it created the error 👍

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RobPL ,

If you want to bypass the error when postcodes are invalid, you can use below formula for the Gallery:

SortByColumns( AddColumns( Directory, "Miles", Value( Round( IfError( BingMaps.GetRouteV2( TextInput1.Text,postcode, {distanceUnit:"Mile"} ).travelDistance, -1 ), 0 ) ) ), "Miles", SortOrder.Ascending )

So, when a postcode is invalid, the distance in the Gallery display as -1 and let users know something is wrong.

Best regards,

Was this reply helpful? Yes No