cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philkky12
Helper I
Helper I

Update one column in a table that has required columns

I have a table that has multiple required columns (they are already populated). I want to patch an additional optional record but it is asking me for all of the other required columns, how do I get around this?

1 REPLY 1
Drrickryp
Super User
Super User

@philkky12 

If you are patching a single record that already exists, then you can use Patch(ds, ThisItem, {columnvalue:...}).
If you have a one to many relationship between the existing record and additional optional values for that column, perhaps you should consider a child table for those values.  If you are adding a completely new record, you will have to provide values for the required columns.  

Helpful resources

Announcements
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.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,952)