collection issues

(0) Share

Report

Posted on by jsmith87

297

Hi all,

I have a dropdown of postcodes and in my gallery i have a label with contractor postcodes. I'm using big maps to calculate the distance. The miles are displayed in a label. I would like the gallery to go in ascending distance order......i hope that makes sense.

I have created a collection to collect the mileage in the label and called it Miles

In my gallery i have the below code, how do i amend this to sort in ascending order based on the collection?

Filter(Table,postcode = Dropdown3_1.Selected.Result)

My Button has this code

Collect(Miles,{Name:CollectMileage})

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jsmith87 ,

How do you calculate the distance ? Could you please show me the formula?

Usually, this can be done by adding a distance column to the data source:

Sort(

AddColumns(

Filter(Table,postcode = Dropdown3_1.Selected.Result),

"distance",

calculate the distance

),distance

)

Best Regards,

Bof
jsmith87 297 on at

Like
a
(0)

Report
Copy link

Link copied!

BingMaps.GetRouteV3("Driving",start1.Text,end1.Text,{distanceUnit:"Mile"}).travelDistance

is the formula i used to work distance
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jsmith87 ,

Please try:

Sort( AddColumns( Filter(Table,postcode = Dropdown3_1.Selected.Result), "distance", BingMaps.GetRouteV3("Driving",StartColumnName,EndColumnName,{distanceUnit:"Mile"}).travelDistance ),distance )

Best Regards,

Bof