Patch Collection to Dataverse: Error is: Invalid Argument Type (Table). Expecting a Record value instead.

[tkomar1]

I was watching & following along with Reza Dorrani's video on creating an editable table in Dataverse but can't seem to get the Patch function to work.

Table Name: 

Unique Identifier in the Table:

OnVisible of my screen:

OnChange within my gallery: 

All of that shows no errors and the collection populates as changes are made: 

But I get an error on the Patch function; OnSelect of a Button:

Any ideas?  Thanks in advance for your time.

[v-xiaochen-msft]

Hi @tkomar1 ,

I can't reproduce your problem.

I suggest you use forall() function instead of Patch() function to add multiple records at once.

For example:

ForAll(your collection As A, Patch(your dataverse table,Defaults(your dataverse table),{Column1:A.Column1, Column2:A.Column2,...}))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[tkomar1]

Hi Wearsky,

Thanks for your response; I previously had it set up as a ForAll function straight from the gallery (no collection), but was noticing performance issues which is why I thought using a collection might be faster.  Do you mean Patching from the gallery or a ForAll function for the collection? I have tried this before and keep coming up with the same issues so am wondering what I'm doing wrong.  I may not be doing the ForAll properly; the collection column names are cre92_vacationhours and it's looking for just 'Vacation Hours'.  I tried renaming the columns previously but couldn't get that to work either.

Error Msg:

Terri