Get a count from SharePoint list

[mwenn1]

Would be nice to be able to gather a count of items in a SharePoint list with a certain status, or category, etc.  Or be able to use the count related to send information.

[CLetona]

I am 100% agree with you

[gamoraes]

HI @mwenn1 and @CLetona

There is already a method to do this.
In the print below i use a GetItens with filters and a Compose after this. in the Compose you should use this text : "@length(body('PegarAprovacoesPendentes')?['value'])" where the text in red is the name of your GetItens action.

I hope I have helped, if you need more can call me.

Best Regards,

Gustvo Moraes

[DrFlex]

Thanx a lot Gustvo!!!

Did work for me. Needed this solution!

[Janeba]

Perhaps it's just me but i still don't understand the solution... can someone please elaborate for me.

[yayala]

Hi 

What happen when the result of "getItems" has more than 100 items? Any advice?

[gamoraes]

Hi @yayala.

You can change the maximun count in SharePoint get itens, i think that the limit is 1000. I change this and work, look at this picture

After this the action get all results existing in my list: 

[yayala]

Thanks

[Nethi]

What if the count is around 3000 and keeps growing?

Would flow willl be able to handle the list of items with count of 10000+

[RyanXExner]

You can actually get the count via a SP Rest call to the /ItemCount endpoint: https://sharepoint.stackexchange.com/questions/231870/how-to-get-listitem-counts-via-rest-api/231872

Getitems will work, but you'll hit the SharePoint item limit and return a lot of unwanted data.  Since this call only returns a number, it has a quick response.