Convert latitude and longitude to address

[RayRay]

Hi there, I have created a Flow with a Flic button to send me the latitude and longitude of my position to an excel file.

How can I generate a full address with zip code, city and street from latitude and longitude?

Regards,

Ray

[Brad_Groux · Accepted solution]

Flow certainly has the capability to do so, you just need to use a map service API to do the conversion. There is a Bing Maps connector in preview that you may want to look into. I've used this API and it works great for mapping out coordinates based on longitude and latitude. I'm not sure if it works the other way around or not.

With that said, any map API with conversion ability should work, check out the official docs for creating a custom connector for a web API. 

Other links:

• Google Maps Geocoding API Request Format
• Building a Location Beacon Using Microsoft Flow, Power BI, and Azure Functions

[RayRay]

thanks, after a few tries it worked then.

[v-yamao-msft]

Hi @RayRay ,

Please consider using the Bing Map connector.

First, please create a connection by providing a Bing map API key:

https://docs.microsoft.com/en-us/bingmaps/getting-started/bing-maps-dev-center-help/getting-a-bing-m...

Second, set up the flow like below.

You may need to get the latitude and longtitude from the trigger with the following code:

triggerBody()['location']['coordinates']['latitude']
triggerBody()['location']['coordinates']['longitude']

Hope it could be a reference for you.

Best regards,

Mabel

[FotomanFE]

How did you get this to work? I a, trying to do the same thing. 

[MH3]

Hi @v-yamao-msft ,

I have an Attendance application, in which when a user checks in, I store their latitude and longitude in SharePoint List, and then at 9:30 AM, a Flow runs which sends an email a PDF Report to the Manager of all employees of checked in for the day.

but now, I want to add in the flow to show the location address with the help of the latitude and longitude of every user who checked in.

Anyone help?