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?
Solved! Go to Solution.
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 ?
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.
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.
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 ?
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.
Flow now does support Stored Procedure calls over On-Premises Data Gateways. Here are the steps to enable it:
Hope it helps.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!