Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

Like (0) Share

Report

Posted on 14 Apr 2023 14:16:31 by WO-23071515-0

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?

All responses (5)

Answers (0)

WO-23071515-0 on 28 Apr 2023 at 20:46:44

Like (0)

Report

Re: Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

Hey @timl thank you very much for your help, but this didnt work. It gives the same coercion type error.
timl 35,217 Super User 2025 Season 2 on 17 Apr 2023 at 05:06:10

Like (0)

Report
Re: Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

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)),
WO-23071515-0 on 15 Apr 2023 at 21:07:41

Like (0)

Report

Re: Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

@timl
WO-23071515-0 on 15 Apr 2023 at 21:06:41

Like (0)

Report

Re: Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

I'm calling patch function on a form.
timl 35,217 Super User 2025 Season 2 on 14 Apr 2023 at 16:11:10

Like (0)

Report

Re: Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

@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?