Skip to main content

Notifications

Community site session details

Community site session details

Session Id : AgeefYzsxPvuixV4Wmufnv
Power Automate - General Discussion
Unanswered

How to use return a string from SQL Server Stored Procedure ?

Like (1) ShareShare
ReportReport
Posted on 22 Aug 2016 12:02:37 by 1,724

I want to use my Stored Procedure's return a string value.

For send email which body is then string.

 

Regards,

Yoshihiro Kawabata

Categories:
  • PJ Profile Picture
    Microsoft Employee on 27 Nov 2018 at 15:21:51
    Re: How to use return a string from SQL Server Stored Procedure ?

    In order to do this, you can use "select into" if that's what you really want to do.

     
    SELECT MyNeededColumn
    INTO JustMyNeededDataTable
    FROM MyReferenceTable;
     
    If what you're trying to do is simply parse the output of the stored proc, you can create a Condition action and iterate over the values using a For Each.
  • Community Power Platform Member Profile Picture
    on 28 Sep 2018 at 14:19:00
    Re: How to use return a string from SQL Server Stored Procedure ?

    HI. could you please let me know how to insert the output of sql stored procedure in another table in sql server.

  • yoshihirok Profile Picture
    1,724 on 23 Aug 2016 at 04:35:53
    Re: How to use return a string from SQL Server Stored Procedure ?

    Hi @Jaden

     

    I use the Action "SQL Server - Execute stored procedure" in my flows.

    and the value "ReturnCode" use in the Condition.

     

     

     

    1.PNG

     

    and, I want to use a string from the Stored Procedure's select.

     

    Regards,

    Yoshihiro Kawabata

  • Jaden Profile Picture
    Microsoft Employee on 23 Aug 2016 at 04:23:51
    Re: How to use return a string from SQL Server Stored Procedure ?

    Have you found and tried the Stored procedure SQL action?

     

    It should allow you to run a procedure, and then in a subsequent action it allows you to use the output as part of the action (e.g. sending the SQL procedure's output as part of the body of that email).

     

    (Attaching a screenshot of where you can select this SQL action).

     

    Untitled.png

    Feel free to post again in case you would like more details/help.

     

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,342 Most Valuable Professional

Leaderboard