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?
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.