I have several agent jobs that it would be EXTREMELY helpful if Power Apps could run them (load and refresh some data from a feed).
Has anyone else done this? They would be on an SQL Server that lives in IaaS not as Azure SQL Service.
Agent jobs usually run as scheduled tasks. What you could try is to create stored procedures and run these from triggers in the table being updated by PowerApps data? Would that work?
Yes, that would be an option.
I take it there is no way to call a stored procedure from power apps directly?
That said, yeah I could make a table and then have the stored procedure UPDATE that table's record with "processing" and "completed" and then Power Apps could just refresh that view waiting for it to finish so the user gets confirmation when all is done.
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021