My filter works with 100 records but not with thousands. What am I doing wrong?

(0) Share

Report

Posted on by CU15060808-0

I am new Power apps , my SharePoint list contains 50,000 records. I use like this in power apps

Filter(
Employees,
Department in ["IT","HR"]
)

The app only returns some results now all

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@CU15060808-0,

If Department is Text column

With(

    {

        dept1: "IT",

        dept2: "HR"

    },

    Filter(

        Employees,

        Department = dept1 || Department = dept2

    )

)

If Department is choice column

With(

    {

        dept1: "IT",

        dept2: "HR"

    },

    Filter(

        Employees,

        Department.Value = dept1 || Department.Value = dept2

    )

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,521 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

"in" is not delegable so will only return 500 or 200 records depending on what data limit you've set. That's why with thousands of items in your list not all of the filtered records are being returned. The solution by @MS.Ragavendar is the way to do it.

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

Was this reply helpful? Yes No
Suggested answer

Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@CU15060808-0

This is usually a delegation issue.

When a formula cannot be delegated to the data source, Power Apps processes only the first 500 records (or up to 2,000 if configured). The remaining records are ignored, leading to incomplete or incorrect results.

Always check for delegation warnings and use delegable functions whenever possible.

Microsoft Reference

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Was this reply helpful? Yes No