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" }
)
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!
WarrenBelz
254
Most Valuable Professional
MS.Ragavendar
134
stampcoin
117