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.
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/
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.
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 @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
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2