Announcements
The Power Apps team release this "dynamic schema" as experimental feature in 2020: Authoring formulas with dynamic schema in Power Apps | Microsoft Power Apps. This is a great feature that let us query database (for example, Azure Data Explorer) directly in Power Apps.
But now I cannot find this option in "Upcoming features":
Have Power Apps team given up on this feature?
I can't seem to find it either. Without this option, I'm not sure how to use smartsheets as a data source using the smartsheets.getsheetdata() function.
Edit: I asked a coworker if they have that functionality and they found dynamic schema in the retired tab...
Edit 2: It was only available on 1 of the many apps that were available to edit. I'm totally confused as to why this setting is not available through all the apps that were created.
Hi @Aryospeedwagon, I later figured out why they deprecated the dynamic schema function. After we retrieve data with the connector, it is stored as an untyped data table (although it is displayed as “unknown” in the variables panel), we can then use data table functions (like clearcollect() and forall(), along with data type functions like text(), value() and so on) to convert the untyped data into regular typed data. With dynamic schema function, it does this job for us. But now we have do it manually
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 103
WarrenBelz 82 Most Valuable Professional
wolenberg_ 67 Super User 2026 Season 1
