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

Notifications

Announcements

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,223 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard