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

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.

 

Highlighted

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

Highlighted
Anonymous
Not applicable

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

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (8,627)