Skip to main content
Community site session details

Community site session details

Session Id : cyWdaGsX3G0A96FwfE/wMb
Power Apps - Building Power Apps
Answered

Calculating Distance between Two Points in Forms

Like (0) ShareShare
ReportReport
Posted on 12 Oct 2020 10:06:58 by 95

Hi all,

Attached is a sample copy of a customizable form I'm doing. 

My objective is to calculate the distance between two inputs - Vendor Address and Destination. I understand that this can be done using the BingMap get distance function. However. this will require the data source as BingMap. In this case, my datasource is a form linked to a sharepoint list. How do I achieve my goal?

Alois_0-1602497101034.png


Thanks,
Alois

  • RamyaSai Profile Picture
    6 on 21 Jul 2021 at 02:22:44
    Re: Calculating Distance between Two Points in Forms

    PLease let me know how to do the same based on sharepoint List

     

  • Alois Profile Picture
    95 on 13 Oct 2020 at 04:02:16
    Re: Calculating Distance between Two Points in Forms

    Thank you so much for the help! How do I postfix the units?

  • Verified answer
    rsaikrishna Profile Picture
    3,703 on 12 Oct 2020 at 11:46:39
    Re: Calculating Distance between Two Points in Forms

    @Alois 

     

    Add BingMaps data source to your app. 

     

    In the your SharePoint list form, select data card for Distance control. 

     

    In the default & Update property, place the following formula:

    BingMaps.GetRoute(tbVendorAddress.Text, tbDestination.Text).travelDistance

     

    If you want the Units of distance as well, then you can postfix the above value with distanceUnit

     

    Give a try and share your results.

     

    Regards

    Krishna Rachakonda

    If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete