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

 

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

 

 

 

1.PNG

 

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

 

Regards,

Yoshihiro Kawabata

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.

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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 (4,244)