cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gyprakas
Level: Powered On

Dynamic fields in Data Table

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()). 

PowerApp1.JPG

"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)).

PA2.JPG

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? 

1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamic fields in Data Table

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,224)