Table in collection

[Nass]

Hello

i have a collection like this :

Collection {

    Column_1:"data1",

    Column_2:"data2",

    Coumn_3: table { 

                                 Column_:"data3" 

                    }

}

and i want to convert this collection into :

Collection {

  Column_1:"data1",

  Column_2:"data2",

  Column_3:"data3"

}

[mdevaney]

@Nass 

You can UNGROUP the collection like this

ClearCollect(new_collection, Ungroup(your_collection_name, "Column3"))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[v-yutliu-msft · Accepted solution]

Hi @mdevaney ,

Do you want to transfer table1 to table2?

Table1:

Column_1, Column_2, Column_3(Column_)

Table2:

Column_1, Column_2, Column_3

If so, if you only use Ungroup() function, you will get table like this:
Column_1, Column_2, Column_

The nested field name will replace Column_3 field name.

So you also need to use RenameColumns() function.

Try this formula:

ClearCollect(new_collection, 
             RenameColumns(
                            Ungroup(your_collection_name, "Column_3")，
                            "Column_","Column_3"
                           )
             )

Best regards,

[Nass]

Thank it works !