Answered

how do I patch an item that I've created using the addcolumn function?

(0) Share

Report

Posted on by jjanowskiRR

I've used the addcolumn function here: (This code sits in the items part of the gallery)

AddColumns(
 Students,
 "Here?","Yes")

However, I am unable to amend the column value to either yes, no or late using a patch.

I'm trying to do it on a button press within a gallery . Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-mengmli-msft on at

Like (1)

Report
Hi @jjanowskiRR ,

The table returned after using AddColumns cannot be used to update records, you need to save the result as a collection first, and then update the collection.

ClearCollect(COL,AddColumns( Students, "Here?","Yes"))

Best regards,

Rimmon

Was this reply helpful? Yes No
jjanowskiRR 58 on at

Like (0)

Report

Thanks - I am struggling to update the buttons and have any success. Where should I put the code above, in the gallery items or on the button itself? Neither is yielding any success - Thank you for taking the time to offer your help

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (1)

Report

Hi @jjanowskiRR ,

You can put it on OnVisible of screen and change Items of gallery to the collection.

Your original Patch formula should work.

If above doesn't fix your problem, please provide some screenshots about your app and Patch formula.

Best regards,

Rimmon

1 people found this reply helpful.

Was this reply helpful? Yes No
jjanowskiRR 58 on at

Like (0)

Report
I've managed to make it work. I've got the gallery to update the attendance register by filtering in students from a master list. Thank you for your help. I'm now stuck on how to reset the student list back to its original state so when a teacher takes a register the next day it doesn't show the last set of data...
ForAll( Gallery4.AllItems, Patch( Students, LookUp(Students, Name = ThisRecord.Name,{status: "x"})))

I'm using status: x as it didnt like the blank(), or status: "". the error im getting is attached. Any ideas?

Screenshot 2024-0...

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @jjanowskiRR ,

Please try this.

ForAll( Gallery4.AllItems As C, Patch( Students, LookUp(Students, Name = C.Name),{status: "x"}))

——————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.

If you have another question, please post it as new question in the forum.

Best regards,

Rimmon

Was this reply helpful? Yes No