Feb 02 2021 05:53 PM
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
Feb 03 2021 04:50 AM
@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:
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:
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&w=560&cp=[$Latitude]~[$Longitude]&lvl=16&typ=d&sty=r&src=SHELL&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