cancel
Showing results for 
Search instead for 
Did you mean: 

Being able to write SQL statement in the formula

Hi,

 

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.

 

Thank you.

Ian

Status: New
Comments
Super User

Hi @aow 

 

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 Heerden
Follow on Twitter: @davestechtips
Subscribe 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.