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.
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
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...
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.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.