Skip to main content

Notifications

Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / .
Power Automate - Building Flows
Answered

.

(0) ShareShare
ReportReport
Posted on by Hii_iii 691
Categories:
Business Process Flows
  • Verified answer
    Hii_iii Profile Picture
    Hii_iii 691 on at
    Odata query true/false
    .
  • Verified answer
    David_MA Profile Picture
    David_MA 11,517 Super User 2025 Season 1 on at
    Odata query true/false
    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:
  • Hii_iii Profile Picture
    Hii_iii 691 on at
    Odata query true/false
    .
  • Suggested answer
    David_MA Profile Picture
    David_MA 11,517 Super User 2025 Season 1 on at
    Odata query true/false
    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
    Hii_iii 691 on at
    Odata query true/false
     
  • Suggested answer
    SwatiSTW Profile Picture
    SwatiSTW 582 Super User 2025 Season 1 on at
    Odata query true/false
    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.
     

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

News and Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community

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

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans