Announcements
Hello,
I want to change a textfield of multiple datasets wich are filtered by two values. First I tried it with the UpdateIf statement but the filter of this statement is not performant (blue underlined) so that just the first 500 entries are editable. So I tried to set the sorting to descending but then I can't use the UpdateIF statement. The Patch statement wasn't a success at all too.
Need help please. Thanks.
Hi @mandert
What do you mean by 'multiple datasets'? Is it one data source with multiple rows?
What is the back-end? (I.e. SP lists, SQL Server etc.)
What do you mean by 'filtered by two values'? Are you filtering on two columns or filtering on one column for two values? In any case, what are the column types and the filter you are trying to apply?
hi @Meneghino
oh yeah sorry. Yes I mean one data source and I want to change the value of a field in multiple rows. I want to select the rows with a filter that has two criteria connected with an '&'. Looks like: Filter('Data Source'; Date = ThisItem.Date & Name = ThisItem.Name)
In the beginning I had: UpdateIf('Data Source'; Date = ThisItem.Date & Name = ThisItem.Name; {Status = "Test"})
Status is a textfield. This statement worked until we reached 500+ records.
I tried then UpdateIf(Filter(SortByColums('Data Source';Date;SortOrder.Descending); Date = ThisItem.Date & Name = ThisItem.Name; {Status = "Test"})...but this did not work.
We use Share Point lists.
I understand that your list has more than 500 items, but are you also trying to update more than 500 item at one time?
If not, then the solution should be simple.
No I don't try to update more than 500 records.
But I read that an inperformant filter (blue underlined) just seaches in the first 500 records.
Thats why I tried it with the descending sorting.
OK, I think this should work:
UpdateIf(Filter('Data Source'; Date = ThisItem.Date && Name = ThisItem.Name); True; {Status = "Test"})
You will still see the blue underlining, but you can ignore it if you are not trying to update more than 500 records at one time, even if the total number of records in your source is >500 records.
Hi @Meneghino,
unfortunately it didn't work.
I tried your formula AND a edit version:
UpdateIf(Filter(SortByColumns('Data Source';"Date";SortOrder.Descending); Date = Today() && Name = ThisItem.Name );true;{Status: "Test"})
But nothing want to work.
I tried it once with a Patch statement but I'm to stupid to select multiple rows with it.
I think the latest PowerApps update broke the UpdateIf function.
Please see here.
Let's see if MS react
@Meneghino wrote:Hi @mandertI think the latest PowerApps update broke the UpdateIf function.Please see here.Let's see if MS react
Well... what a surprise.
Do you think there is a work around for this e.g. with PATCH?
Yes, you can probably use a Patch inside a ForAll loop. But you will probably need to disambiguate the ID column.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
