A new feature in Power Apps allows for calling SQL Stored Procedures directly from the app. This feature returns an UnTypedObject, but this article explains how to type cast tables coming from SQL Server stored procedures in Power Apps. The article discusses two approaches: the slow approach using a ForAll loop to convert each column, and the faster approach using the AddColumns function to type cast each column without looping through the data. The code examples provided demonstrate how to implement both approaches.
Login now to access my digest by 365.Training