I can execute a stored procedure using Logic Flows but how can I fetch the data from the result set, cause just executing the SP and not getting any data will not make any sense.
What kind of data do you want to get when you execute stored procedure? How do you want to get the data?
Followed by “Execute stored procedure”, you could add other actions such as “Create file” with Dropbox, “Send an email” with Office 365 Outlook, etc. So please try to create flows followed by other actions to fetch the data you want.
I am passing some parameters from PowerApps then executing the SP the result set that is returned from the SP that I need to display in my app.
I had the same issue, go see my solution at the link below.
1.call from the flow your SP.
2. then where you want to return the parameter put: body('yourSPName')?['ResultSets']?['Table1']??['YourColumnNameReturned']
Don't seem to be able to make this work
Here is the call to the SP
Here is the step which uses the result of the SQL call
Here is the output from the SP
Here is what the email looks like
Can't see what I am doing wrong. Anybody spot it?
So I had this same issue and the fix is somewhat odd. The formula is probably correct but it seems you have to enter it into the Expression box. So expand the Add Dynamic Content pane, select the Expression tab, and then copy and paste your body() tag into that text box. Then click Ok. You will note that it creates a tag of the expression you entered and now it will actually get processed correctly. It appears you can't just type in the path without going throught the Expression tab.