Hi All,
I would really appreciate any help because i really need to get this done.
I have two dropdown fields in PowerApps each pulling from a SharePoint list(mileage_distance). Both dropdowns store the same location and I want if a user selects a location in dropdown 1 and another location in dropdown 2, that a third field (text field) shows the distance between those two locations. The distance is also from the mileage_distance list
Please see attached milage_distance excel doc attached as well as a preview of my app.

Thanks for your assistance,
Alton