Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building 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

  • ANB Profile Picture
    7,075 Super User 2025 Season 1 on at
    Re: Error using Patch with SQL table

    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,695 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard