It would be great if we can write our own SQL statement (Eg. Insert into '[datasource].table, values....) on the OnSelect event.
In this case, we can also run Stored Procedure command.
Currently, patch function is not very flexible. I am trying to patch a number into a decimal column but it is not working.
Please consider this.
I agree this would be great.
In the meantime, see below 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.