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.
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.
Flow now does support Stored Procedure calls over On-Premises Data Gateways. Here are the steps to enable it:
Hope it helps.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.