So when I use this function...
Update(Products;Gallery1.Selected; {cantidad: "sad"}) // to update(modify) a record(field) in a excel table GIVES ME this [PowerAppsId Required Field]
I can update an excel table using Forms, but I want to push a button to be updated
HELP ME PLS
Solved! Go to Solution.
I fixed it using Patch(Productos_Compra; Gallery1.Selected; {cantidad: "sad"})
Looks like Patch() is the wae 🤗
Is your Excel stored in Onedrive, does the table have PowerAppsId?
Kindly check if you already have the Id remove the table and reconnect again.
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
I fixed it using Patch(Productos_Compra; Gallery1.Selected; {cantidad: "sad"})
Looks like Patch() is the wae 🤗
@Anonymous
Yes, Patch is the way to go.
For info, Gallery1.Selected does not expose the PowerAppsId field. That's the reason why Update doesn't work.
User | Count |
---|---|
158 | |
99 | |
83 | |
77 | |
59 |
User | Count |
---|---|
196 | |
173 | |
103 | |
95 | |
89 |