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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.