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
[videopress I5g3yUfx]
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.
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. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://staging.sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://staging.sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@staging.sharepains.com
Leave a Reply
You must be logged in to post a comment.