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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

.

(0) ShareShare
ReportReport
Posted on by 691
Categories:
I have the same question (0)
  • Suggested answer
    SwatiSTW Profile Picture
    807 Super User 2026 Season 1 on at
    1. Please enable pagination, By default, the "Get Items" action in Power Automate retrieves only 100 items per batch. Enabling pagination allows you to increase the batch size (e.g., 200+), ensuring that all items are fetched. Without pagination, only a subset of the list items will be returned, causing you to see fewer results than expected.
    2. Check OData Filter,  The filter query (Plus_vendeur eq false or Plus_vendeur eq 0) ensures that only items where the "Plus_Vendeurs" column is false are retrieved. The correct syntax depends on how the boolean column is represented in SharePoint (either as false/true or 0/1). An incorrect filter would result in unexpected or no results.
     
  • Hii_iii Profile Picture
    691 on at
     
  • Suggested answer
    David_MA Profile Picture
    14,080 Super User 2026 Season 1 on at
    You said your field is true/false. This is counterintuitive, but update your filter query to remove the expression and the single quotes around it. Just use Plus_Vendeurs eq 0 for the expression. With true/false values in filter queries, 0 = false and 1 = true.
  • Hii_iii Profile Picture
    691 on at
    .
  • Verified answer
    David_MA Profile Picture
    14,080 Super User 2026 Season 1 on at
    Since I cannot verify the data in your SharePoint list I need to take your word that there are more than 10 items meeting these criteria. However, the expression is correct and will return up to 100 items if you do not enable pagination or change the threshold limit.
     
     
    Without pagination or increasing the threshold, it returns the max 100 items:
  • Verified answer
    Hii_iii Profile Picture
    691 on at
    .

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard