BingMaps.GetRoute - calculate distance and duratio...

Anonymous · ‎03-24-2021

Hi,

i am using Bingmaps.GetRoute in a label within a gallery (as i have to calculate distance and duration for multiple people listed in the gallery). I have currently got 2 separate BingMaps.GetRoute() labels - 1 for distance and 1 for duration. however this makes double the API call. I want to be able to retrieve the JSON in 1 call and use this 1 response to just show duration and distance either in 2 separate labels (ideally) or in 1 if needs be.

Thanks

v-xiaochen-msft · ‎03-24-2021

Hi @Anonymous ,

I did a test for you .

1\ This is my test collection 'Col'.

2\ Add a gallery control and set its Items property to:

AddColumns(Col,"Test",BingMaps.GetRoute(A,B))

3\ Insert a label into gallery and set its Text property to:

ThisItem.Test.travelDistance

4\ Insert a label into gallery and set its Text property to:

ThisItem.Test.travelDuration

5\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Anonymous · ‎03-25-2021

Hi, the issue or what i think the issue is that my gallery is currently filtered by a drop down that the user selects from a list of options and this brings back users and their post code from CDS. How do i add the postcode labels to the collection- they will change according to the drop down option and the users in the list. Also how do i then use addcolumns with the filter on the gallery which is currently - filter('table' -from cds, name in combobox.selecteditems.name) as the user can select multiple options from the combo box

v-xiaochen-msft · ‎03-25-2021

Hi @Anonymous ,

Addcolumns() function can be used on cds directly , you don’t need to create another collection.

So, you could use this formula on Items property of gallery control.

Addcolumns(filter('table' -from cds, name in combobox.selecteditems.name),New Name,BingMaps.GetRoute(...,...) )

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Anonymous · ‎03-26-2021

Hi, when i use a collection of the user postcode it brings it back in what seems to be a nested collection.
The first image is what i see initially, followed by image 2 when i click into postc and if i click into any of the nested collections it shows the users post code under text. I just need the collection to retrieve the userpostcode which is the Text and destination, which i have no idea how to do. As shown below the post codes are currently listed in a gallery connected to cds table. The user can enter the destination which will be the same for all users in the gallery.

v-xiaochen-msft · ‎03-28-2021

Hi @Anonymous ,

Please try ungroup() function.

For example:

This is my test collection.

Use this formula:

Ungroup(Ungroup(Col3,"Haha"),"Test2")

The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Anonymous · ‎03-30-2021

thanks for the response, the ungroup worked just by using one ungroup(collection, "postcode"), however what do i do if there is more than 1 nested table to access and need to combine the data.

also if i try to do addcolumns to the filtered gallery, it doesnt work as i need to use the collection data with addcolumns . i want to be able to ideally use the collection data which gets the bingmaps data and bring it back to the same filtered gallery