Skip to main content

Notifications

Community site session details

Community site session details

Session Id : q1gtCJR5giJ3SxM/6rFIs/
Power Automate - Using Flows
Answered

SQL Stored Procedure - Output parameters

Like (0) ShareShare
ReportReport
Posted on 6 Feb 2019 14:22:56 by 587

Source is a SQL Server, it on premise and connected through a gateway.


From Flow I call a Stored Procedure, in which I have declared an output parameter

@XMLFile XML OUTPUT

Now I don't get back the output parameters from my stored procedure, see picture
2019-01-24 10_37_38-Edit your flow _ Microsoft Flow.png

 

I noticed when I do this in an Azure SQL Server instance, so whithout a data gateway, it will return the output parameter as expected.

 

So my question is if anybody knows if this is a bug, a limitation or If I'm doĂŻng something wrong?

 

Hope someone can help.

 

Paul

  • Kinson-Lam (WCC) Profile Picture
    36 on 26 Jun 2024 at 05:16:04
    Re: SQL Stored Procedure - Output parameters

    Hi @v-yamao-msft , 4 years has passes, have this limitation been solved?  How can I get an output parameter from a stored procedure when calling from Power Automate?  

  • marles Profile Picture
    4 on 15 May 2023 at 16:08:58
    Re: SQL Stored Procedure - Output parameters

    Hi

     

    I got the output value using a function substring() with "Resultsets". For this operation, i had to create some variables before containing lenght about "Resultsets" and position number for some characteres to identify since and until. 

     

    Regards

     

    Mitchel Arlés

  • Verified answer
    v-yamao-msft Profile Picture
    on 08 Feb 2019 at 09:11:47
    Re: SQL Stored Procedure - Output parameters

    Hi @KroonOfficeSol,

     

    When invoking a Stored Procedure on an on-premises SQL Server, we have the following limitations:

    • Output values for OUTPUT parameters are not returned. You can still specify input values for OUTPUT parameters.
    • Return value is not available.
    • Only the first result set is returned.
    • Dynamics schemas are not supported for result sets.

    Please check the following doc for more details:

    https://docs.microsoft.com/en-us/connectors/sql/

     

    Best regards,

    Mabel

     

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

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 7 Super User 2025 Season 1

#2
vipuljain03 Profile Picture

vipuljain03 4

#3
VictorIvanidze Profile Picture

VictorIvanidze 2

Overall leaderboard

Featured topics

Restore a deleted flow