Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Advanced Flow Help: Comparing two address lists

Hey all- 


I just need some help constructing a flow to calculate the closest location for a client.

Basically I have two Sharepoint lists, I need to get the address from the client address list (list 1), then see which address is closest to them (list 2). Anyone want to tackle this with me?  


Your help is very much appreciated, and the more details the better!





Hey there.  Sounds like an interesting challenge, what do you have so far?

One approach might be to get the lat/long using the Bing Maps connector and then calc the distances using some algorithm, sort ascending, and choose the top hit.

Other options could be 3rd party plugins, or even D365 Field Service, if you're already using that.


Keep us posted.




If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (3,155)