Announcements
Dear All,
Please need your Help.
I have a Huge Sharepoint list more than 10000 Rows and getting more and more, How can I get the count for All Sharepoint Items ??
looking for a solution not delegable.
Waiting for your support.
Hi @Mo_gamal ,
This might be a solution for you to stop trying - with all the delegation issue (CountRows is not delegable) and the way PowerApps loads data, it cannot I believe be done. I found this article to explain it
Hey @Mo_gamal, I have a quite dirty workaround for you, which only works, if you do not delete any items in this list... In one of my lists I use the ID of my SharePoint Items for this. Like:
Last(DataSource).ID - First(DataSource).ID
Otherwise you might need to collect your list in separate collections like @mr-dang shows in his workaround
and count the rows of these different collections...Still not a very handy way to deal with such a simple problem...
I think this should be possible without any of these workarounds...
Hi @KChristoph
Ingenuity never ceases - and it will probably work for @Mo_gamal .
It would not work for in our case as we archive items, but I did however forget the absolute obvious with a SharePoint list - just put a Count total on a view of a field that always has data in it and get the total numbers in SharePoint (which is on every one of of lists) and will count to 120,000 in a document library we have.
Albeit this is a relatively old thread I nonetheless thought it was worth mentioning that I've recently published a blog on my website that in essence describes in detail how you can use a flow leveraging the SharePoint / Graph REST APIs that surfaces the total count of items in any given SharePoint library or list passed as a parameter to the flow, following which returns the value to the calling Power App in a Respond to PowerApp or flow step.
I have shared a link to download flow in my blog. It is highly resuable and should work with any list or library in your SharePoint tenant. It does not require premium connector licensing. Hopefully it will be of use to other app makers coming across this thread in the future!
Get SharePoint Library or List Total Items from Power Apps
https://masteroffice365.com/get-sharepoint-library-or-list-total-items-from-power-apps/
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 993
Valantis 675
11manish 545
