Announcements
@kushalhedaoo07
This looks like valid syntax. Can you post the error that you're receiving?
A couple of things I'd check is that EmployeeID is properly defined as a primary key field in SQL Server. The Patch operation will fail because of this. I would also check that the value you enter in TextInput1 is a unique number, as a duplicate ID value would also cause an error.
Yes, I will ensure the EmployeeID is unique and all details are correctly filled. Despite this, the error persists with the message indicating an invalid argument for the 'Patch' function. SQl server permission is require?
make sure you have no triggers in sql server
@kushalhedaoo07 also expand the error message out by giving us the https error returned. Use IfError for this purpose, and it will give you and those helping you a lot more insight to the actual issue.
Patch functions don't have descriptive error messages, so we need to get the root error message to debug.
yes there is triggers in sql server then how to solve problem
@kushalhedaoo07 You have to remove them - Powerapps can not patch if they exist in sql server. Hopefully this does not make a difference for you
powerapps will handle things like assigning nulls to values and other similar simple functions triggers sometimes do, however if you are using your triggers for some larger function you are going to have to find another way besides using a trigger
ok i will try thanks for reply
No problem, mark as solution whatever the solution ends up being for you and kudos anything that was helpful!
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
