cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoshihirok 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.

 

Regards,

Yoshihiro Kawabata

4 REPLIES 4
Highlighted
Microsoft
Microsoft

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.

 

yoshihirok Memorable Member
Memorable Member

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

Anonymous
Not applicable

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.

Microsoft
Microsoft

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.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (7,276)