Unanswered

Bing Get Route - Travel Distance

(0) Share

Report

Posted on by Richard4

Hi All, I have connected Bing Apps to a SharePoint list that contains addresses. I have successfully used Bing to get the latitude and longitude of these addresses and populate the list correctly. Next, I want to use Bing Get Route to populate the list with the Travel Distance between each address and a fixed address. I have tried different configurations and cannot seem to get it working. When I Test the Flow, it tells me that it has succeeded. When I run the flow, everything works perfectly except getting the Travel Distance. Please see a screenshot of my Flow below. Any help with getting the SharePoint list populated with each Travel Distance is much appreciated!

Categories:

Building Power Apps

Screencapture_Flo...

I have the same question (0)

All responses (8)

Answers (0)

BCLS776 8,994 Moderator on at

Like (0)

Report

Try the Bing Map Get Route instead of the Get Route V2 function. I was having troubles with the V2 connector returning a blank routeDistance a couple of days ago and it still isn't working. The old, deprecated connector is working.

The issue has been reported to Microsoft Support, but no resolution yet.

Hope that helps,
Bryan

Was this reply helpful? Yes No
Richard4 8 on at

Like (0)

Report

Hi Bryan, thanks for your help. I have tried swapping out the function like you suggested but it still won't populate the Travel Distance to the list. I have simplified the flow but it will still only populate the list with the coordinates and not the Travel Distance. Please see the screenshot below. Any help is much appreciated!

Screencapture_Flo...

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

Richard, could you look at the Run History for your flow and see what the input/output looks like at the travelDistance step? It sounds like coordinates are passing out successfully from earlier steps, so I am curious if you are getting a valid output at that step.

Was this reply helpful? Yes No
Richard4 8 on at

Like (0)

Report

Hi Bryan, I have taken a look and the Get Route has a text output that seems to be the route as requested. But it doesn't seem to be able to get the Travel Distance from the Get Route to pass it to the variable or the Sharepoint List.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

There should be a specific field in the output from the GetRoute operation that gives the travelDistance value. You might have to browse through quite a lot of other route info to find it. It should look like:

travelDistance: "34.373"

With some other number in there.

If it isn't there, or it is blank/invalid/etc. then there is a problem with the connector. Note that for the support ticket.

Was this reply helpful? Yes No
Richard4 8 on at

Like (0)

Report
Thanks Bryan. I have taken a look at the output and can see the full route information with travelDistance values mentioned throughout and the final entry is:
"travelDistance":137.873
I have also taken a look at the code for the Set variable 2 if it helps:
{ "inputs": { "name": "DistanceVar", "value": "@{outputs('Get_route')?['body/travelDistance']}" } }

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

Hi Richard,

Microsoft did provide an update to the support ticket I launched about issues with the Bing Maps connector. They have done some work on it and thought they had it resolved; however, I still see issues with it on my end. It looks like it will be a bit longer before we know we have a reliable connector.

Bryan

Was this reply helpful? Yes No
Richard4 8 on at

Like (0)

Report

Hi Bryan, thanks for your help. At least I know it's not me that's the problem!

Was this reply helpful? Yes No