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