Call a stored procedure or SQL Agent job?

[Questions]

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!

[kierian]

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.