web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Error using Patch with...
Power Apps
Unanswered

Error using Patch with SQL table

(1) ShareShare
ReportReport
Posted on by 4

Hello there.
I need some help please.

WallasNava_1-1721101898584.png

 

WallasNava_2-1721102005317.png

 

 

I have this error when i try to use a table i have in SQL.

Even when i'm writing the code i receive as suggestion other tables (where i can use without problem patch command)

I would like to know if you please could help me to know what's happening and what can i do to make it work

Categories:
I have the same question (0)
  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @WallasNava , Whenever you post a query on forum, please try to translate the error message for quick response. 

     

    I see that the error says " The "Patch" function has some invalid arguments." Please correct me if I am wrong.

     

    The syntax and code looks good here, please make sure that all column name that you are patching here are correct spelling. The table should have Primary Id column and it should Id INT IDENTITY(1, 1) NOT NULL

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB


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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 335 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 96 Super User 2026 Season 1

Last 30 days Overall leaderboard