Showing results for 
Search instead for 
Did you mean: 
Memorable Member
Memorable Member

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

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

For send email which body is then string.



Yoshihiro Kawabata


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).



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


Memorable Member
Memorable Member

Hi @Jaden


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

and the value "ReturnCode" use in the Condition.






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



Yoshihiro Kawabata

Not applicable

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

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.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,076)