Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

UpdateIf with a large table

Like (0) ShareShare
ReportReport
Posted on 1 Feb 2023 14:39:51 by 31

Hi everyone,

 

I've a table of 6k data and I would to use UpdateIf, but doesn't work over the 2k.

 

Can you help me?

 

This is an example of my code:

 

 

 

UpdateIf(
 Table;
 And(
 FirstName = "John";
 Value(Year) < 35
 ); 
 { Access: "YES" }
)

 

 

 

  • Verified answer
    LaurensM Profile Picture
    12,510 Super User 2025 Season 1 on 01 Feb 2023 at 17:14:37
    Re: UpdateIf with a large table

    Hi @DavidePF90,

     

    UpdateIf() is indeed not delegable, meaning it will only look at the first 500 to 2000 records. However if you are using Dataverse as a data source, this may change in the near future (see wave 1 2023 release plan).

     

    A current possible workaround is by using a ForAll() on a filtered data set. In your case this would be:

     

    With(
     {
     source: Filter(
     Table;
     FirstName = "John" && Value(Year) < 35
     )
     };
     ForAll(
     source;
     Patch(
     Table;
     ThisRecord;
     {Access: "YES"}
     )
     )
    )

     

    If this solves your question, would you be so kind as to accept it as a solution.

    Thanks!

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 134

#3
stampcoin Profile Picture

stampcoin 117

Overall leaderboard