cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gglennon
Frequent Visitor

Power Apps interactive map control has maxpins set to 1000, but the map only shows 25 pins.

The Power Apps interactive map control has maxpins set to 1000, but the map only shows 25 pins.

My datasource is an Excel table on OneDrive with 351 rows of coordinates. When I start the app, the correct number of pins is shown, 351. If I navigate away from, and then back to, the screen containing the map, the map displays a maximum of 25 pins.

I created the app using the "Start with Data>Excel Online" option; then I added a new screen and added the interactive map control to the new screen.

I then re-created the app starting from a SharePoint List of the same data, with the same result. 

What do you think? Anyone else having this problem/issue (bug)?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

This works (I just tested it with a SQL connection):

For the screen containing the map control (MapScreen), set OnVisible=Refresh(yourDataSourceName).

Previously, I was trying to refresh the datasource using a refresh button on the BrowseScreen. But I think you have to do the refresh after you return to the MapScreen to get >25 pins to display.

I imagine this is a pretty expensive work-around if the user navigates away from, and then back to, the MapScreen a lot, and there are a lot of pins.

View solution in original post

7 REPLIES 7
v-jefferni
Community Support
Community Support

Hi @gglennon ,

 

I made a test and found the issue. Then I tried some workarounds, my data source is Excel worksheet in OneDrive too.

56.png

map_pin.gif

Clear(colPins);Collect(colPins,Table1)

As you seen, I split the ClearCollect function so that the collection be created every time the map screen shows, and the Items of the Map control was refreshed just like it connects the data source every time but not refresh the data source.

 

Please have a try. If there is other problem, please let me know.

 

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution  to help the other members find it.

That's a great workaround! I'm not sure why it's needed, but it works. Thanks so much for the quick response!

I spoke too soon. The workaround stopped working. Is Microsoft limiting the maxpins to 25?

Thanks!

Hi @gglennon ,

 

Could you please share more details about "stop working"? Did the map stop show the whole pins but 25 still?

 

As per the performance of the map control, it seems that the control would show all pins while connect with data source, so I provide the workaround that make the map connect with data source every time it appears. 

 

Best regards,
Community Support Team _ Jeffer Ni

Hi,

Try navigating away from the map control to a different screen, even manually using the Studio; I think you'll find that a maximum of 25 pins are shown when you return to the map, regardless of how many are in the datasource. I've tried this with Excel, SharePoint, and SQL Server as the datasource, all with the same result.

Another MVP that I contacted said that he has also encountered some issues regarding resetting of pins and that he was going to meet with the Product Team to discuss the issue. 

I think I'm going to wait for a fix or GA release from Microsoft before using this control in my app.

Thanks again!

 

 

This works (I just tested it with a SQL connection):

For the screen containing the map control (MapScreen), set OnVisible=Refresh(yourDataSourceName).

Previously, I was trying to refresh the datasource using a refresh button on the BrowseScreen. But I think you have to do the refresh after you return to the MapScreen to get >25 pins to display.

I imagine this is a pretty expensive work-around if the user navigates away from, and then back to, the MapScreen a lot, and there are a lot of pins.

View solution in original post

TatianaWakim
Regular Visitor

Hello,

 

I have the same problem but with 45 pins instead of 25.

My collection contains 128 rows, and I am using a SQL connection.

I've tried the workaround that you proposed but it didn't work for me. Even on start of the app, my map shows only 45 pins.

@gglennon did you manage to get all of your 351 pins on the map or is Microsoft limiting the maximum number of pins?

 

Thank you.

Regards,

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,343)