Make nested fields their own columns in a data table

(0) Share

Report

Posted on by aec2018 Microsoft Employee

I have a data table component populated by JSON from our API. Some fields are nested and I can't seem to get these nested fields to be recognized as their own column. When I try to edit the fields to add these, I only get the option to add "NestedField" as a whole as one column. So for example, we would get a response like such:

{
"Field1": "Value1",
"Field2": "Value2",
"NestedField": {
 "NestedField1" : "NestedValue1",
 "NestedField2" : "NestedValue2"
}
}

My table headers should be:

I was thinking that I would need to use ClearCollect() to create the initial items for the table, and then use Collect() to go in, grab each nested value, and manually add it as a column. The closest I've gotten is adding these columns but they end up on their own row instead of included in their respective row. How can I accomplish this? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

aec2018 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I was able to figure it out from another comment in another post. I used the following formulas to create a new table with flattened data from my original table:

ClearCollect( NewFlattenedTable, AddColumns( OldNestedTable, "NewColumn1", First(OldNestedTable).NestedField.NestedField1, "NewColumn2", First(OldNestedTable).NestedField.NestedField2 ) )

Then I set the Items property of my data table to NewFlattenedTable and the columns were available to be added to the data table.

Was this reply helpful? Yes No