Announcements
Hi All
Is there any way to show a total SharePoint List items count in PowerApps without loading a whole list (the list is quite big - around 30k and getting bigger)The info is already in SharePoint in SP Site contents view - Items column. So the question probably is - is there is any way to get that info from SharePoint Site contents view?
Thanks
Yes, however, it involves calling a Power Automate flow. You can use a 'Send an HTTP request to SharePoint" action to retrieve the itemcount of the list. Here is how mine looks:
_api/web/GetFolderByServerRelativeUrl('/sites/site-name-here/Lists/list-name-here')/itemcount
Ensure there are no spaces in the above. You should be able to copy the needed part directly from the URL when viewing the list.
Hello @romankorchak2
I have looked through your case and so far there is no quick way of counting rows without also loading the data.
I would like to recommend the use of Flow for this case. Below is what you need to get the RowCount for a List.
Uri used in Action:
_api/web/lists/getbytitle('List_Name')/itemcount
The expression used in getting the value:
body('Send_an_HTTP_request_to_SharePoint')['d']['ItemCount']
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.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
