Update data from text input in gallery

[Anonymous]

I have a problem, i don´t know if anyone could help me, since last week i´m trying to update text i put in a textinput i have in a gallery but i dont find the way to update my data table that i have in one drive, if anyone could help me i would be very glad.

[jhall]

Keep in mind that the Update() function has some unique aspects vs. say a Patch() or UpdateIf() function.

Is "Racks_1" the name of your DataSource or a local Collection?

Also, if your DataSource is an Excel table then you aren't live-linked to that if you directly imported it into PowerApps.  You are just holding a copy of that table's contents in-memory within your app and cannot write directly to an Excel document.

[v-yutliu-msft · Accepted solution]

Hi @Anonymous ,

Do you want to update a record in PowerApps?

Firstly, you need to know the differences between the Update function and Patch function.

Update function is used to replace a record. It means that the original data of that record will be totally replaced, including all the fields.

Patch function can only update some fields in one record.

According to your formula, I think maybe you want to update 'GAM 610 METAL' field of this record.

So I suggest you use the Patch Function.

Try this formula:

Patch(Racks_1,LookUp(Racks_1,con...=Label7.Text),{S1:TextInput2.Text})

Here're docs about Patch and Update for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif

Best regards,

Community Support Team _ Phoebe Liu

[Anonymous]

thank you so much for your answer, i just have 1 more doubt,

in this formula: Patch(Racks_1,LookUp(Racks_1,con...=Label7.Text),{S1:TextInput2.Text})

i´m trying tu put this part of the formula ({S1:TextInput2.Text}) but i don´t have result yet.

S1 is the column when i wanna update my records.

if you could leave a comment i will be very glad with your help

Best wishes, Vicente.