Unanswered

Function Patch has invalid arguments

(1) Share

Report

Posted on by CU01102042-0

Hello Teammates,

I have put in all my todays effort to figure out this error. I have sql server database and table name powerbicomments. I am trying to insert a new record to the table . Please see below screenshot

I checked the database and the datatype is matching as well. I am not sure what is wrong with it and would need some expert recommendation to resolve it.

Thank you guys in advance for helping me with this

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

EddieE 4,641 Moderator on at

Like (0)

Report

It's possible you need to add 'Required' / Not-NULL fields into your Patch record. All Not-NULL fields need to be included, except for any fields auto generated by SQL, such as Timestamp and Auto-increment fields like Primary Key fields, etc

Was this reply helpful? Yes No
CU01102042-0 4 on at

Like (0)

Report

I added the code . This is my code still the same error

// Store data in the context variable

UpdateContext({

submittedData: {

ClinicId: Value(TextInput3.Text),

ClinicName: TextInput2.Text,

Comments: TextInput1.Text,

CreatedOn: DatePicker3.SelectedDate

}

});

// Insert the data into the PowerBIComments data source

Patch(

PowerBIComments,

Defaults(PowerBIComments), // Use Defaults to create a new record

{

ClinicId: submittedData.ClinicId,

ClinicName: submittedData.ClinicName,

Comments: submittedData.Comments,

CreatedOn: submittedData.CreatedOn

}

);

Was this reply helpful? Yes No