cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

PowerAppsId Required Field >:(

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I fixed it using Patch(Productos_Compra; Gallery1.Selected; {cantidad: "sad"}) 
Looks like Patch() is the wae 🤗

View solution in original post

3 REPLIES 3
eka24
Super User
Super User

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.

Anonymous
Not applicable

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.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,012)