Show total SharePoint List items count

(0) Share

Report

Posted on by romankorchak2

125

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

JasonZF 572 on at

Like (0)

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

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
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']

Was this reply helpful? Yes No