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.
Solved! Go to 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
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.
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
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.
User | Count |
---|---|
252 | |
104 | |
94 | |
50 | |
39 |