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
Hi
Did you ever figure out how this self resolves? I keep getting it randomly. Have a simple SQL server view and get this error.
Hi @omi18 ,
It seems that your problem has been solved.
Maybe you could consider marking your reply as a 'Solution' to close the case.
Best Regards,
Charlie Choi
Never mind after some time it started to work. No changes were needed.
Thanks,
WarrenBelz
142
Most Valuable Professional
MS.Ragavendar
81
stampcoin
68