Unanswered

Dynamic Table() from sharepoint

(0) Share

Report

Posted on by ThomasDC

Hey,

I'm trying to get dynamic push pins on a bings map based on a sharepoint list. My way of thinking is making a dynamic table and replacing the latitude and longitude based on the table or sharepoint list. The format for a pushpin is:

pp=latitude,longitude;1;name

Getting a dynamic table however is hard and I can't figure out how to do it. Can someone show some example codes?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-liwei-msft on at

Like (0)

Report

Hi @ThomasDC ,

Could you please tell me if you want to use SharePoint as the data source to display this pushpin on the map when a new item is updated？
I have made a test for your reference:
1.Set up data sources:

2.Add an image control to the screen and enter this formula in the image property:
"https://dev.virtualearth.net/REST/v1/Imagery/Map/Road/47.619048,-122.35384/15?mapSize=500,500&"&
Concat(map,"pp"&"="&latitude& ","&longitude&";"&yangshi&";"&name,"&")&
"&key=Your key Url"
The Concat function connects the items in the data source as a string. I think this link will help you a lot :Concat and Concatenate functions in Power Apps - Power Apps | Microsoft Docs.

3.I think this link will help you a lot: https://docs.microsoft.com/en-us/bingmaps/rest-services/imagery/get-a-static-map

Beat Regards,
Levi

Was this reply helpful? Yes No
ThomasDC 60 on at

Like (0)

Report
@v-liwei-msft,

Thanks for getting back to me. I've tried the concat function however it failed to work as it simply does not display the map for me. I'm using the following code;

"https://dev.virtualearth.net/REST/v1/Imagery/Map/Road/" &Substitute(DCVLatitude.Text;",";".")&","&Substitute(DCVLongitude.Text;",";".")& "/15?mapSize=500,500&"& Concat(Locations;"pp"&"="&Latitude& ","&Longitude&";1;"&Id;"&")& "&key={MyKey}"

However the image returns blank. The key is working, since I've got a map up with 1 singular pushpin. These are my Sharepoint columns:

EDIT: Found out the issue! Latitude and Longitude were saved with a comma (,) instead of a (.). This can be fixed with either the substitute formula or simply by changing the data in the list!

Was this reply helpful? Yes No