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!
Thank you so much @David_MA ! That worked! 😀
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:
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 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>
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492