Hello All,
I'm trying to use the patch function to send data from Power apps to the SQL server table. I have been using this same patch function in other apps and it is working fine.
This is a new table and a new app I'm working on and getting this error. " The Key Didn’t match any rows in the table. Inner exception".
And SQL table has an Identity column.
This is what I have OnSelect property of the button.
Patch(
'databse',
{
Request_Date: Today(),
Request_Department: RS_Select_Dept.Selected.Result,
Request_Description: RS_Description.HtmlText,
Request_Semester: RS_Select_Sem.Selected.Result,
Request_Year:Year(Today()),
Request_Status:"Pending Approval",
Requestor_Name:User().FullName,
Requestor_Email:User().Email
}
);
Any Suggestions?
Thanks,
Omi
