Answered

Calculating Distance between Two Points in Forms

(0) Share

Report

Posted on by Alois

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?

Thanks,
Alois

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

rsaikrishna

3,703 on at

Like (1)

Report

Copy link

Link copied!

@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 Solution. Marking 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.

Was this reply helpful? Yes No

Alois 95 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RamyaSai 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No