I want to use my Stored Procedure's return a string value.
For send email which body is then string.
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.
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.
In order to do this, you can use "select into" if that's what you really want to do.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.