Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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? 

  • 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 Profile Picture
    timl 34,222 on at
    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)),
  • Re: Error while patching: "No coercion operator is defined between types 'System.Guid' and 'System.String'."

    @timl 

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

    I'm calling patch function on a form. 

    Williams_O_0-1681592531204.png

     

  • timl Profile Picture
    timl 34,222 on at
    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?

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard