Power Platform Community Forum Thread Details

hi mates,

i am successfully send a data to stored procedure with parameters now my question is how i can retrive the data from stored procedure to Microsoft power automate desktop

i am using this query for sending a data can someone help me to fetch the data from stored procedure

EXEC InsertEmployee @FirstName = %CurrentItem[0]%, @LastName = %CurrentItem[1]%, @CompanyName = %CurrentItem[2]%,@JobRole = %CurrentItem[3]%,@email='uk@gmail.com', @PhoneNumber = %CurrentItem[4]%

Categories:

Power Automate Desktop

@imumeriqbal01

It seems like you're utilizing a stored procedure to insert employee records, and you're interested in knowing how many rows are affected in the table after each insertion.

So, I've made a slight modification to your SQL statement below, where the row-affected count is retrieved as the output.

If you're experimenting any other stuffs, could you please provide more details on what you're aiming to achieve?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀