Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / Execute Stored procedu...
Power Automate - Using Connectors
Answered

Execute Stored procedure with On-Premises Gateway server

(0) ShareShare
ReportReport
Posted on by trbleile 39

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:
General Questions
Connecting to Data
  • Kaine Profile Picture
    Kaine 74 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    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

  • BARD Profile Picture
    BARD 40 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    Still looking for this functionality

  • kevinsray Profile Picture
    kevinsray 209 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    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.

  • ChuckSisson Profile Picture
    ChuckSisson 4 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    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.

     

     

  • ChuckSisson Profile Picture
    ChuckSisson 4 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    Is there any update?  Is this available now?

     

    Thank you

  • giag1211 Profile Picture
    giag1211 2 on at
    Re: Execute Stored procedure with On-Premises Gateway server

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

  • anatal52 Profile Picture
    anatal52 8 on at
    Re: Execute Stored procedure with On-Premises Gateway server
  • shaunwilks Profile Picture
    shaunwilks 31 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    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 ?

     

  • BitLord69 Profile Picture
    BitLord69 914 on at
    Re: Execute Stored procedure with On-Premises Gateway server

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

  • mkelly Profile Picture
    mkelly 2 on at
    Re: Execute Stored procedure with On-Premises Gateway server

    Could you provide an example of this, please?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans