It would be great to have examples of how to configure the flow to execute SQL queries with custom parameters.
Below are two videos dealing with advanced queries to SQL from PowerApps (using Flow).For SQL Azure you can use direct (native) queries:https://youtu.be/DII10gK715I
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:https://youtu.be/BAGBzI4zdww
Please let me know if you don't come right.
Dawid van HeerdenFollow on Twitter: @davestechtipsSubscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1**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.