cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Power Automate Staff Sunay
Power Automate 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. 

View solution in original post

13 REPLIES 13
Power Automate Staff Sunay
Power Automate 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. 

View solution in original post

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

Power Automate Staff Sunay
Power Automate 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: Powered On

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.

BARD
Level: Powered On

Re: Execute Stored procedure with On-Premises Gateway server

Still looking for this functionality


Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,575)