cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trbleile
Level: Powered On

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Flow Staff Sunay
Flow Staff

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. 

12 REPLIES 12
Highlighted
Flow Staff Sunay
Flow Staff

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. 

nickchobotar
Level: Powered On

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 ? 

Anonymous
Not applicable

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 Sunay
Flow Staff

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

mkelly
Level: Powered On

Re: Execute Stored procedure with On-Premises Gateway server

Could you provide an example of this, please?

Super User
Super User

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?

shaunwilks
Level: Power Up

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 ?

 

anatal52
Level: Powered On

Re: Execute Stored procedure with On-Premises Gateway server

 
giag1211
Level: Power Up

Re: Execute Stored procedure with On-Premises Gateway server

I'm not able to connect to the stored procedures on Prem. Can someone provide details as to how it can be done?

ChuckSisson
Level: Power Up

Re: Execute Stored procedure with On-Premises Gateway server

Is there any update?  Is this available now?

 

Thank you

ChuckSisson
Level: Power Up

Re: Execute Stored procedure with On-Premises Gateway server

Getting -  "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Get Native Sql Metadata) is currently not supported using an on-prem gateway connection clientRequestid: F8CBC37B-2699-4873-8909-8869C84F7A4A.

 

 

kevinsray
Level: Powered On

Re: Execute Stored procedure with On-Premises Gateway server

Any luck with this?
I am getting the same when trying to create a flow to execute a SQL query, but it doesn`t seem to like the onprem gateway.

>