I get the above error while trying to update records in my SQL able. I pulled data from this table into power apps using the "external table" functionality.
I can create new records fine with the patch > defaults function but I can't update existing records because of the above issue.
Any help please?
Hey @timl thank you very much for your help, but this didnt work. It gives the same coercion type error.
Hi @Williams_O
I'd change the following line as follows. Hopefully, that'll fix the problem.
ID_SITE: If(IsBlank(VarSiteinfor), GUID(), GUID(VarSiteinfo.ID_SITE)),
I'm calling patch function on a form.
How are you updating your record? Are you calling Patch or are you using a form? If it's the former, can you post your formula?