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.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!