The Key Didn’t match any rows in the table

Like (0) Share

Report

Posted on 17 May 2022 14:24:31 by omi18

640

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

Categories:

Dataflows

General Questions

Connecting to Data

All responses (3)

Answers (1)

jimmy6365 10 on 15 Apr 2023 at 20:36:59

Like (0)

Report

Re: The Key Didn’t match any rows in the table

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.

"Message": "Error when trying to retrieve data from the network: The key didn't match any rows in the table. inner exception: The key didn't match any rows in the table. clientRequestId:
v-yujincui-msft on 20 May 2022 at 05:41:21

Like (0)

Report

Re: The Key Didn’t match any rows in the table

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
Verified answer

omi18 640 on 17 May 2022 at 14:46:42

Like (0)

Report

Re: The Key Didn’t match any rows in the table

Never mind after some time it started to work. No changes were needed.

Thanks,