CREATE PROCEDURE PROC ... always up to date. To use SQL Server connections in Power Apps, we just add a connection to our app and now we can use data from the table that we selected.