Hello,
We are trying to use Flow/Power Automate with a SQL Server store procedure in order to get a few columns of data.
Currently we were able to successfully setup one flow with a stored procedure, but when trying to setup a second one using a stored procedure that uses a sub-query, we were not able to grab the columns that we need.
I would be happy to share more information as needed if anyone is willing to help.
Thank you,
HI @Anonymous
Do you get the columns when you run the stored procedure outside Flow? The structure of the stored procedure is not relevant for Flow. The action runs the procedure and gets the results, so if there are fewer columns it's probably an issue in the stored procedure.
Can you please check this and provide a little bit more information if it doesn't work so that I can try to help you?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
Share
Report
All responses (
Answers (
6,643
