web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : hOcwV2CoH/PbQvml07tjZz
Power Apps - Building Power Apps
Unanswered

Count All Items in SharePoint List (Huge List)

Like (0) ShareShare
ReportReport
Posted on 27 Jan 2020 09:55:24 by 15

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.

Categories:
  • beallthings365 Profile Picture
    10 on 04 Mar 2022 at 17:26:24
    Re: Count All Items in SharePoint List (Huge List)

    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/

  • WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 27 Jan 2020 at 11:26:22
    Re: Count All Items in SharePoint List (Huge List)

    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.

  • KChristoph Profile Picture
    62 on 27 Jan 2020 at 10:34:40
    Re: Count All Items in SharePoint List (Huge List)

    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...

  • WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 27 Jan 2020 at 10:15:05
    Re: Count All Items in SharePoint List (Huge List)

    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

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.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete