Power Platform Community Forum Thread Details

I'm having an Invalid Argument Type (Table). Expecting a Record Value instead error.

I have a SQL table with 27 columns but not all of it should be editable.

Only 5 or 6 columns are needed to be updated via Power Apps.

I'm watching this tutorial on how to bulk update or add records into a SQL table.

I tried copying the part @11:00 and @14:00 of the video.

But when I try to apply it on my case, it is not working.

I have a gallery which user can edit specific columns each row and when they click "Done" an item will be added to a Collection like shown in the video.

Here's the content of my collection:

01 Patch.jpg

Here's my code of adding record inside the Collection.

02 Patch.jpg

Here's the Patch function inside my Save button

Patch(STAGING_LTC_BE_AUDIT,ShowColumns(colRowUpdates,'Auditor Name','Care Manager Name','Decision','Initial_Ongoing','IsEdited','Live_Post','Id'));

I tried also using

Patch(STAGING_LTC_BE_AUDIT,colRowUpdates);

But no luck.

I eventually realized this won't do because what if I need to add a whole new set of record and I can't restrict the insertion of columns only to 5 or 6.

So I decided to change this part and used ThisItem to add a record in the collection.

03 Patch.jpg