web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Bing Get Route - Trave...
Power Automate
Unanswered

Bing Get Route - Travel Time and Distance

(0) ShareShare
ReportReport
Posted on by 14

Hello,

I am new to this community but hopeful I support on this issue.

 

Target :

To get travel time and distance to add in a column in a Sharepoint List.

 

What’s working :

Bing Get Route is connected successfully and produces the right output when viewed after the flow runs.

 

Whats not working :

When using Travel Distance or Time dynamic output in the Sharepoint update item, it returns an empty field.

 

What was attempted :

compose, convert to string and all whats entering in any flow after the bing get route passes no data.

 

everything seems to run as it should but outputs are not showing as expected.

 

Assistance would be truly appreciated.

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,183 Most Valuable Professional on at

    Hi @Dev88,


    I can reproduce this behaviour when I use the TravelDistance field myself. When I peek the code of that column it points to body/TravelDistance.

     

    However, that doesn't correspond with the schema of the response of the Get Route action. It probably is a bug in the connector.

     

    To workaround this you could use this expression in a compose action to get the total distance of your route:

     

    outputs('Get_route')?['body']['resourceSets'][0]['resources'][0]['travelDistance']

     

     

    For travel duration in seconds you could use this expression:

     

    outputs('Get_route')?['body']['resourceSets'][0]['resources'][0]['travelDuration']

     

     

    For travel duration with traffic in seconds you could use this:

     

    outputs('Get_route')?['body']['resourceSets'][0]['resources'][0]['travelDurationTraffic']

     

     

     

  • Dev88 Profile Picture
    14 on at

    @Expiscornovus you are awesome, this worked like a charm !. 

  • Zhenya Profile Picture
    123 on at

    Thank you for work around! Definitely a bug. Odd that if to use existing  template from library that use Bing Connector to calculate distance it works correctly. Adding within flow yes, doesn't return results. Copy and trying paste to another gave error that Schema doesn't match. 

  • Dev88 Profile Picture
    14 on at

    Update 08/31/21 : 

     

    Noticed that the flow is now failing due to wrong expression was working fine and after looking into it It seems that its now fixed and the right expression now is now without ['resourceSets'][0]['resources'][0].

     

    Distance : 

     

    outputs('Get_route')?['body']['travelDistance']

     

    Duration : 

    outputs('Get_route')?['body']['travelDuration']

     

    Duration with Traffic : 

     

    outputs('Get_route')?['body']['travelDurationTraffic']

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard