cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoshihirok
Level 10

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
Microsoft Employee

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
Level 10

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.

Highlighted
Microsoft Employee

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,015)