Type cast tables coming from SQL Server stored procedures in Power Apps


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.


Article 10m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time