cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
suhailsalim

Database stored procedure

Submitted by Advocate I on ‎09-10-2018 03:52 AM

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

Status: New
3 Comments (3 New)
Comments
tchin-nin
Memorable Member
Memorable Member
‎09-10-2018 04:08 AM

You can consider using Flow to do the job.
https://youtu.be/MoifwDFKSTo

WPB
Kudo Kingpin
Kudo Kingpin
‎05-13-2019 12:00 PM

You may consider voting here: Link

Smiley Very Happy

DavesTechTips
Super User
Super User
‎08-26-2019 09:57 AM

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:
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.