cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trbleile
Helper I
Helper I

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
Sunay
Power Automate
Power Automate

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

14 REPLIES 14
Sunay
Power Automate
Power Automate

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

Support for this is coming by end of the year. 

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

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.

Sunay
Power Automate
Power Automate

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

Could you provide an example of this, please?

BitLord69
Memorable Member
Memorable Member

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

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
Frequent Visitor

 

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

ChuckSisson
New Member

Is there any update?  Is this available now?

 

Thank you

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.

 

 

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
Advocate II
Advocate II

Still looking for this functionality


Kaine
Advocate I
Advocate I

Hi,

Flow now does support Stored Procedure calls over On-Premises Data Gateways. Here are the steps to enable it:

 

  1. In Flow, from the Execute stored procedure (V2) step, select the ellipsis menu, top right.
  2. At the bottom of the context menu, select + Add new connection.
  3. In the Authentication Type drop-down, select either SQL Server Authentication or Windows Authentication to reveal the Gateway options.

 

Hope it helps.

 

- Kaine

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,177)