Today I found in on of my app an unexpected behaviour in related to paging in Power Apps Galleries.
I first thought that it was related to the experimental feature that I found earlier today. However this feature apparently already existed before but I never noticed it.
Count rows on galleries
Table of Contents
At the top right you can see the number of items loaded in my gallery calculated with the following expression.
CountRows(Gallery1.AllItems)
Paging in Power Apps
As I scroll down my gallery, Power Apps automatically loads the next 100 items from the SharePoint datasource. This new way of loading data seems to improve the performance of my gallery, however I can imagine that I might have to adjust some of my app where I’m relying on the usage of CountRows to give me the number of items that I’ve got in a SharePoint list.
When doing a CountRows on your data it might be better to go back to the data source or collection used to feed the Gallery.
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. You can contact me using contact@sharepains.com