Announcements
I have a flow set up already that works fine, but I'm wondering if there is a more efficient way to set it up?
Here is how it is set up:
I received this warning message when I saved it:
Any thoughts/ideas? Thanks!
You can use the following HTTP request on your list:
/_api/web/lists/getbytitle('List Name')/ItemCount
Put the following in the header of the HTTP request:
{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" }
You can then parse the JSON to get the number of items in the list. The value will be returned in ItemCount. For example:
<d:ItemCount xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" m:type="Edm.Int32">6009</d:ItemCount>
Sorry, I'm sort of a beginner+ at all this, so I'm not sure I really understand/know how to do that. I tried, but...
You need to use an HTTP Post request rather than a Get and for the body, you need to switch the headers to text mode and paste what I posted that way (click on the T icon to the right of headers). The flow will look like this:
You should be able to use this for the Parse JSON Schema since this is a standard SharePoint request:
{ "type": "object", "properties": { "d": { "type": "object", "properties": { "ItemCount": { "type": "integer" } } } } }
This is what it returns:
Thank you so much @David_MA ! That worked! 😀
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.
Haque 552
Valantis 388
11manish 375
