I want to create a power app that needs to call a stored procedure (or kick off a job) to process some data and then once it completes, display the result.
I was hoping perhaps Flow could be used to call the stored procedure/SQL agent job and then handle that and return to power apps?
Has anyone had any luck doing this or can you suggest how I could best accomplish this task?
Thanks!
Hello
you can use power automate sql connector to call store procedure and trigger this flow from power apps
Execute SQL stored procedure on a recurring basis | Microsoft Power Automate
Have a good day.