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

Notifications

Announcements

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
    741 Super User 2025 Season 2 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
    12,982 Super User 2025 Season 2 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
    12,982 Super User 2025 Season 2 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

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 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard