web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Count SharePoint Items
Power Automate
Unanswered

Count SharePoint Items

(0) ShareShare
ReportReport
Posted on by 505

I am looking for a way to count the number of items in a SharePoint list and apply to a condition that if it =16 to go to the next step.

Categories:
I have the same question (0)
  • Verified answer
    RobElliott Profile Picture
    10,313 Super User 2025 Season 2 on at
    Re: Count SharePoint Items

    @send2mark in your get items action make sure you go to settings, turn the pagination toggle on and set the threshold to a number higher than the number of items in your list. If you don't do this it will only bring back a maximum of 100 items.

     

    Add a compose action and add the expression: length(body('Get_items')?['value'])

     

    0-Threshold.png

     

    1-Expression.png

     

    2-Result.png

     

    You can then add a condition after that to check if the output of the compose = 16.

     

    Rob
    Los Gallardos
    Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard