SubmitForm ERROR when creating new record to SQL DB "network error when using Patch function, specified record was not found"

(0) Share

Report

Posted on by mrjz

Hi all.

I have a simple test APP on SQL DB.

APP has 3 screens - gallery, details and form (as you get with a standard wizard

When inserting new record I get an error : "network error when using Patch function: specified record was not found"

The new record is actually getting inserted into the table.

The Monitor shows :

I've Created new connection to the SQL DB, made New App etc. The table I'm trying to insert data has an PK (Varchar).

Editing a record works OK (no error messages) but when creating a new one we get an error. (On my test SQL server (on prem) I can submit data from form without any errors shown. )

Any help appreciated.

Can I somehow validate and not show an error when the record is actually inserted to the DB?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@mrjz

Several questions before troubleshooting. Are you submitting a form or using a patch? Are you specifying the ID in the form or the patch? Have you made changes to the form once it has been created?

I also suggest using the Monitor to give you a hint about where the problem is but my guess is it has something to do with the ID field.

Was this reply helpful? Yes No
mrjz 4 on at

Like (0)

Report

Hi
I've tried with the Form and with the Patch function on Button.
I've also tried default Form (as created by the wizard), tried modifying Form-s dataccards etc.
My question is why do I get such an error when I try to create NEW record (It's a new record so how can it be found?) ? The error shows up but the record gets inserted anyway!

And at the same time when I use my own on-prem test SQL DB I do not get the same error.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@mrjz

Bing says:

The error message "network error when using Patch function, specified record was not found" usually occurs when there is an issue with the SQL Table connection from your canvas app². You can try removing the SQL Table connection from your canvas app and then re-adding it again in your canvas app. Within your Patch formula, re-reference the SQL Table data source and then try your Patch formula again². This should solve the issue.

Source: Conversation with Bing, 4/17/2023
(1) SubmitForm ERROR when creating new record to SQL DB "network error when .... https://powerusers.microsoft.com/t5/Building-Power-Apps/SubmitForm-ERROR-when-creating-new-record-to-SQL-DB-quot-network/td-p/2110694.
(2) Solved: The Specified record was not found/Resource not fo... - Power .... https://powerusers.microsoft.com/t5/Building-Power-Apps/The-Specified-record-was-not-found-Resource-not-found-error/td-p/666960.
(3) Solved: Submitform Network error when using Patch function... - Power .... https://powerusers.microsoft.com/t5/Building-Power-Apps/Submitform-Network-error-when-using-Patch-function-The-requested/td-p/1892006.

Was this reply helpful? Yes No
mrjz 4 on at

Like (0)

Report

I've already tried all those ideas - created absolutely new APP with new connections, I've deleted the connections in the same APP and recreated them.

Was this reply helpful? Yes No