Automate Flow to warn when nearing 2,000 SharePoint items (for Power Apps Canvas App)

(0) Share

Report

Posted on by axray

244

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!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

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

Was this reply helpful? Yes No
axray 244 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

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

Was this reply helpful? Yes No
axray 244 on at

Like (1)

Report

Thank you so much @David_MA ! That worked! 😀

Was this reply helpful? Yes No