You’re offline. This is a read only version of the page.
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?
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
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.
#1
WarrenBelz
146,601
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,942
Most Valuable Professional
Share
Report
All responses (
Answers (
