Text street address location

Copper Contributor

I have a column in a list with text street addresses in it which were collected in a powerapp from an address input field. Can anyone think of anything cool I can do with that within the sharepoint list 

1 Reply

@lee123680 one of the things you might want to consider is using connected web parts. If you  convert your text street addresses to latitude and longitude you can then use connected web parts to display related information. For example, on our intranet we have the list of offices and their coordinates:

0-officesList.png

 

On the page about that office we then have an embed web part which takes the coordinates from the list and displays a map of the town from Bing and nearby live restaurant information from Trip Advisor:
1-connectedWebParts.png

 For the map you can see the latitude and longitude columns within the embed code:

<iframe width="560" height="315" src="https://www.bing.com/maps/embed?h=315&amp;w=560&amp;cp=[$Latitude]~[$Longitude]&amp;lvl=16&amp;typ=d&amp;sty=r&amp;src=SHELL&amp;FORM=MBEDV8" frameborder="0" scrolling="no"> </iframe>

..and the same for the restaurants from Trip Advisor:

<iframe width="500" height="400" src="https://www.tripadvisor.co.uk/Restaurants-[$Restaurants]" frameborder="0" scrolling="yes"> </iframe>


Rob
Los Gallardos
Microsoft Power Automate Community Super User