Reply
Level: Powered On
Posts: 18
Registered: ‎10-19-2016
Accepted Solution

Execute Stored procedure with On-Premises Gateway server

Im trying to execute a stored procedure using powerapps, the source of the app is an on premesis server. I saw in the past that it was not possible to run an on-prem stored proc via Flow. Is this possible now? If not, has anyone heard of a time as to when this may be available?

 

Thanks


Accepted Solutions
Highlighted
Flow Staff
Posts: 96
Registered: ‎04-28-2016

Re: Execute Stored procedure with On-Premises Gateway server

Stored procedures are currently not supported with connections going through on-premises gateway. 

Support for this is coming by end of the year. 

View solution in original post


All Replies
Highlighted
Flow Staff
Posts: 96
Registered: ‎04-28-2016

Re: Execute Stored procedure with On-Premises Gateway server

Stored procedures are currently not supported with connections going through on-premises gateway. 

Support for this is coming by end of the year. 

Level: Powered On
Posts: 4
Registered: ‎01-11-2017

Re: Execute Stored procedure with On-Premises Gateway server

Dear Flow Team, 

Any news on executing stored procedure with On-Premises Gateway server ? 

I see from the previous posts plans were made to make this feature available by now. No pressure Smiley Happy just checking if  there is an ETA for that ? 

Level: Power Up
Posts: 1
Registered: ‎01-24-2017

Re: Execute Stored procedure with On-Premises Gateway server

Like many others that are viewing this thread, I registered to post just so I could say that I too am waiting for a solution to Execute a Stored Procedure by way of the On-Premise Gateway server.  Can anyone provide an updated ETA or a possible workaround?  I wanted to create a simple PowerAPP that would connected to my on-premise SQL server and run a simple stored procedure. However, I've only been able to create a PowerAPP that will browse my db tables (and their rows).... Cool, but not exactly useful.  Any information on executing a stored procedure would be appreciated.  Thanks for reading.

Flow Staff
Posts: 96
Registered: ‎04-28-2016

Re: Execute Stored procedure with On-Premises Gateway server

Hi all, a quick update. We have released the ability to run stored procedures via on-premises gateway servers.

Please note that this feature is in Preview.

 

Thanks,

Sunay

Level: Powered On
Posts: 4
Registered: ‎04-06-2017

Re: Execute Stored procedure with On-Premises Gateway server

Could you provide an example of this, please?

Level 8
Posts: 173
Registered: ‎03-20-2017

Re: Execute Stored procedure with On-Premises Gateway server

Any more updates on this topic? Are there any examples how to use the feature directly from PowerApps, not going via Flow?

Level: Power Up
Posts: 1
Registered: ‎09-26-2017

Re: Execute Stored procedure with On-Premises Gateway server

Anyone have any updates on the status of this ?

Was original due out in 2016.

 

If its in Preview mode how do we access the on premise preview version ?