Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 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:

axray_0-1717425895493.png

 

I received this warning message when I saved it:

axray_1-1717425946646.png

Any thoughts/ideas? Thanks!

  • axray Profile Picture
    244 on at
    Re: Automate Flow to warn when nearing 2,000 SharePoint items (for Power Apps Canvas App)

    Thank you so much @David_MA ! That worked! 😀

  • David_MA Profile Picture
    11,517 Super User 2025 Season 1 on at
    Re: Automate Flow to warn when nearing 2,000 SharePoint items (for Power Apps Canvas App)

    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:

    David_MA_0-1717431060202.png

    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:

    David_MA_1-1717431163558.png

     

  • axray Profile Picture
    244 on at
    Re: Automate Flow to warn when nearing 2,000 SharePoint items (for Power Apps Canvas App)

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

    axray_0-1717428186652.png

     

  • David_MA Profile Picture
    11,517 Super User 2025 Season 1 on at
    Re: Automate Flow to warn when nearing 2,000 SharePoint items (for Power Apps Canvas App)

    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>

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.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492