Showing results for 
Search instead for 
Did you mean: 

Database stored procedure

How to make use of SQL Server Stored procedures in PowerApps ?

Status: New
Memorable Member

You can consider using Flow to do the job.

Kudo Kingpin
Kudo Kingpin

You may consider voting here: Link

Smiley Very Happy

Super User

Hi @suhailsalim 


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.