Dynamic fields in Data Table

[gyprakas]

Hi All,

        I am trying to do following:

1- I have a table in Kusto which contains the filter strings.

2- These filter strings should be shown in a table. 

3- When user clicks on an item in this table then based on selection it goes again to Kusto runs a query and returns a result which is this Item values as column and some other columns. 

I made it using flow. I am loading first data table using a kusto flow ClearCollect(Dimensions, GetDimensions.Run()). 

"Dimensions" collection is bound to DataTable1.

Then onSelect property of this dataTable I am invoking another flow which returns the data ClearCollect(Percentiles, KustoFlow.Run(DataTable1.Selected.type)).

It creates a new collection "Percentiles". Now I am binding this collection to a new Data Table2. But catch is that fields of this collection(Percentiles) may vary based on the first data table selection and datatable lets me select only fixed names of fields. Is it possible to make Datatable just take the JSON data and show all the fields in the data? 

[v-yuxima-msft]

Hi @gyprakas ,

Do you want to directly show fields in datatable with JSON?

Please vote:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/JSON-comaptibility-with-the-DataTable/idi-p/1324...

Hope this could be helpful.

Best Regards.

Yumia