How to Get Count of Items in SharePoint List

(0) Share

Report

Posted on by YM-06112112-0

Hi,

I'm a Power Automate newbie, and i'm trying to learn Power Automate by doing.

Im tying to count the number of rows in a Sharepoint List by using the HTTP Rest Sharepoint API. I'm following this tutorial : https://www.powertechtips.com/count-sharepoint-list-items-power-automate/.

Here's the result i get:

Does anyone know why i get this kind of outputs and not a proper Json format result ? Here's my Flow :

In the Uri i actually wrote : /_api/web/lists/getbytitle('Mylist')/itemCount

In the weird output i found the result but in a weird shape:

Thanks in advance.

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

YM-06112112-0 11 on at

Like (0)

Report

Weird result when creating a flow

any help is welcome because I can't figure out what's going on.

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,473 Super User 2025 Season 2 on at

Like (1)

Report
Weird result when creating a flow

Try:

The header:

Accept: application/json;odata=nometadata

Here is the runtime output of my flow. The List has 16,716 items:

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No
Verified answer

YM-06112112-0 11 on at

Like (0)

Report

Weird result when creating a flow

@ekarim,

Thanks for your answer. But sadly it didn't work. Must be a bigger issue within my organization.

Thnaks.

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,473 Super User 2025 Season 2 on at

Like (1)

Report

Weird result when creating a flow

I think the problem is with the Site Address in the Send an HTTP request to SharePoint.

You must specify the SharePoint Site Address only - you have included a URL pointing to a webpage:

Your Site Address seems to be pointing to a List stored in your OneDrive. The HTTP may likely still work, but I haven't had a chance to test it.

I did a write-up of the ItemCount:
Quickly Count Items in Any SharePoint List or Library using Power Automate – Ellis Karim's Blog

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No
Suggested answer

David_MA 12,515 Super User 2025 Season 2 on at

Like (1)

Report
Weird result when creating a flow

I didn't bother reading what is in the link you provided since you're saying it doesn't work. If you just want to get the total count of items in a SharePoint list, your flow will look like this:

Configure the HTTP request as follows being sure to change 'Display Name of List' to the display name of your list. I see other things in the site address in prior replies. You only want what comes after sites/ up to and excluding the next / (essentially, the internal name of your site). Be sure to configure the Uri as shown below but with your list name. The Uri does not begin with a / as you show you your request.

Put the body of the HTTP request into the Compose action.

Run the flow and then copy what is returned in the body of the compose action for the Parse JSON action. Note: DO NOT add the other actions until your run your flow from this point!

For the Parse JSON action, click Generate from sample and then paste in what you copied from the Compose action in a successful run:

Initialize an integer variable and insert the ItemCount from the Parse JSON action:

You can then use the variable wherever you need the value.

Was this reply helpful? Yes No