You’re offline. This is a read only version of the page.
11
No problem, mark as solution whatever the solution ends up being for you and kudos anything that was helpful!
ok i will try thanks for reply
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
@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
yes there is triggers in sql server then how to solve problem
@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.
make sure you have no triggers in sql server
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?
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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
