Patching multiple items in Table

(0) Share

Report

Posted on by MS_Gonzo

Guys,

I feel somewhat embarrassed and humbled.

The entire day, I have been trying somethin, I thought would take me 3 minutes.

I have a table inside a power apps solution called "Durchlauf". I want to patch the column "Abgeschlossen" (Finished) to "Ja" (Yes) for all entries of that table where the Chargennummer (batch no.) is equal to Label1.

The code:

ForAll(Filter(Durchlauf; Chargennummer = Label1.Text); Patch(Durchlauf; LookUp(Durchlauf; Chargennummer = Label1.Text); {Abgeschlossen: "Ja"}))

According to all the Youtube Videos, written articles and least of all, my brain, this should work, however I get a bunch of errors including "LookUp has invalid arguments", something about invalid GUID arguements, patch having invalid arguments, column "Abgeschlossen" not existing, ...

Any help is as always appreciated.

BR,

Gonzo

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MS_Gonzo

Rather than call ForAll/Patch, it would be easier to call UpdateIf to update multiple rows based on a condition.

UpdateIf(Durchlauf; Chargennummer = Label1.Text; {Abgeschlossen: "Ja"} )

You don't mention the data type of Abgeschlossen - if it's a choice column rather than a text column, the syntax would look something like this.

UpdateIf(Durchlauf; Chargennummer = Label1.Text; {Abgeschlossen: Abgeschlossen.Ja} )

Was this reply helpful? Yes No
MS_Gonzo 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. That appears to have done it.
😀

Was this reply helpful? Yes No