Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

On-Prem gateway stop working - Flow


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.

Any ideas? 

(It works perfect with a Azure SQL)

Many thanks


Community Support
Community Support

Hi @Daviid,


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.


Best Regards,


Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for tha awnser Barry!

Unfortunately, it did not work.
When I created a new flow, I was still wrong despite finding the data.

Error Code
  "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:

No fancy at all!



Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,383)