Answered

Execute Stored procedure with On-Premises Gateway server

(0) Share

Report

Posted on by trbleile

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

Categories:

Using connectors

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Verified answer

Sunay Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Stored procedures are currently not supported with connections going through on-premises gateway.
Support for this is coming by end of the year.

Was this reply helpful? Yes No
nickchobotar 6 on at

Like
a
(1)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sunay Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
mkelly 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you provide an example of this, please?

Was this reply helpful? Yes No
BitLord69 914 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
shaunwilks 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
anatal52 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
giag1211 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ChuckSisson 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there any update? Is this available now?

Thank you

Was this reply helpful? Yes No