Showing results for 
Search instead for 
Did you mean: 

Documentation and examples of "Executing SQL queries" directly in a flow

It would be great to have examples of how to configure the flow to execute SQL queries with custom parameters.

Status: New
Level 10

Hi @uvera 


Below are two videos dealing with advanced queries to SQL from PowerApps (using Flow).
For SQL Azure you can use direct (native) queries:


For on-premesis SQL servers, native queries are not supported from Flow (you will get an error: operation Execute Native Sql is currently not supported using an on-prem gateway connection), so we have to use stored procedures to accomplish the same:


Please let me know if you don't come right.


Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube:
**If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.