sort gallery in ascending order from a collection

(0) Share

Report

Posted on by jsmith87

297

Hi all,

I have a gallery that pulls info from a spreadsheet, inside the gallery is a label (CollectMileage) The label calculates distance from what you select in the dropdown (start) to another label in my gallery (end) using the below formula

"Milesfrom site " &BingMaps.GetRouteV3("Driving",Start.Selected.Result,End.Text,{distanceUnit:"Mile"}).travelDistance

Can i use this label (Collectmileage) as a collection and then filter sort the gallery to show how far people are in ascending order?

Gallery

Filter(Table,Dropdown1 = Dropdown1.Selected.Result)

Label

CollectMileage

I'm not great on powerapps so any help would be greatly appreciated. Or if you can tell me how to do it, even better!

Categories:

Building Power Apps

All responses (1)

Answers (0)

HectorOlivos 411 on at

Like
a
(1)

Report
Copy link

Link copied!
You can try with ClearCollect()

You choose from starting the clearcollect OnStart App or from a button:

ClearCollect(collectMileage, AddColumns(Table, "Mileage", BingMaps.GetRouteV3("Driving", Start.Selected.Result, End.Text, {distanceUnit: "Mile"}).travelDistance))

Change your gallery Items to:

Sort(collectMileage, Mileage)

and in a label inside your gallery:

"Miles from site " & ThisItem.Mileage

Hope this helps!