I have been working with an on-prem SQL a long time and suddenly it has completely stopped working.
I can access and see the fields but cant use "insert row".
When I do this message appers:
I have updated the Gateway software on the server and made a new connection, still the same problem.
(It works perfect with a Azure SQL)
Could you provide a screenshot of your Flow configuration?
The error message says that property 'shared_sql_3’ doesn’t exist, available properties are 'shared_sql_1'. Do you have the property 'shared_sql_3’?
I suggest you try to recreate new Flow and update the connection to see if the problem still exists.
Many similar issue are solved by creating a new Flow, and then Flow works well. This seems to be caused by the failure of the connection service to work as expected.
Thanks for tha awnser Barry!
Unfortunately, it did not work.
When I created a new flow, I was still wrong despite finding the data.
"message": "The key didn't match any rows in the table.\r\n inner exception: The key didn't match any rows in the table.\r\nclientRequestId: e28ab69d-fc10-44d5-93dc-ffe8b9f401d7",
Expressions i use is: