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.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
273 | |
252 | |
87 | |
37 | |
34 |
User | Count |
---|---|
346 | |
263 | |
131 | |
68 | |
47 |