power app

(1) Share

Report

Posted on by kushalhedaoo07

Patch(

Employees,

Defaults(Employees),

{

EmployeeID: Value(TextInput1.Text),

EmployeeName: TextInput2.Text,

EmployeeNumber: TextInput3.Text,

Comments: TextInput4.Text

}

);

it show error like the function 'patch' has some invalid argument shows error

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
kushalhedaoo07 11 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report

make sure you have no triggers in sql server

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
kushalhedaoo07 11 on at

Like (1)

Report

yes there is triggers in sql server then how to solve problem

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
developingteal 392 on at

Like (2)

Report

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

Was this reply helpful? Yes No
kushalhedaoo07 11 on at

Like (1)

Report

ok i will try thanks for reply

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report

No problem, mark as solution whatever the solution ends up being for you and kudos anything that was helpful!

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report

What's the status of this/ what's the current error?

Was this reply helpful? Yes No