Announcements
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?
@Williams_O
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?
I'm calling patch function on a form.
@timl
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)),
Hey @timl thank you very much for your help, but this didnt work. It gives the same coercion type error.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
