Changing a cell value of a sharepoint list by clicking a button in a gallery

(0) Share

Report

Posted on by julian11

Hi everybody,

I am creating an Power Apps App to track Event Registrations at our Store.

If a person cancels its registration I would like to have a button which changes the quantity cell (Anzahl, datatype number) to 0 and it should change the value of the Payment Status (dataype choice field) to another value like "cancelled". If so these to changed fields in the App should also change the color to something like red to see that it is cancelled in first view.

List Name: Teilnehmer_Events_PowerApp_2023

Columns to Update: Anzahl (Quantity, datatype number), Zahlstatus (Payment Status, datatype choice)

Thank you in advance for a hint.

Best

Julian

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @julian11

You can update the record by calling the Patch function like so:

Patch(Teilnehmer_Events_PowerApp_2023, LookUp(Teilnehmer_Events_PowerApp_2023,TN-ID=ThisItem.TN-ID), {Anzahl:0, Zahlstatus:{Value:"Cancelled"})} )

This assumes that TN-ID is the unique identifier. You may need to replace the , characters with ; if you're not using the English version of the editor.

Was this reply helpful? Yes No
julian11 13 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @timl ,
thank you very much.

It worked. I just needed to remove the bracket at the end, then it worked. 🙂
Patch(Teilnehmer_Events_PowerApp_2023, LookUp(Teilnehmer_Events_PowerApp_2023,TN-ID=ThisItem.TN-ID), {Anzahl:0, Zahlstatus:{Value:"Cancelled"}} )

I put a pop up window when someone clicks "Storno"(cancell registration). But with a ; or an & Im not able to add the code Set(globalvariable;false).
The code should be:
Patch(Teilnehmer_Events_PowerApp_2023; LookUp(Teilnehmer_Events_PowerApp_2023; ID=galTeilnehmer_Screen4_TN.Selected.ID); {Anzahl: 0; Zahlstatus:{Value:"Storniert"}} ) & Set(varShowPopUpStornoTN;false)
but it does not change the variable to false to hide the pop up.

Looking forward to hearing from you.
Thanks in advance.
Best
Julian

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @julian11

This would be the correct syntax for that:

Patch(Teilnehmer_Events_PowerApp_2023; LookUp(Teilnehmer_Events_PowerApp_2023; ID=galTeilnehmer_Screen4_TN.Selected.ID); {Anzahl: 0; Zahlstatus:{Value:"Storniert"}} );; Set(varShowPopUpStornoTN;false)

Was this reply helpful? Yes No