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.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!