Extract ID from a table inside a Row of Collection

[Ethan_R]

Hi All,

I have a collection which contains a table. That table has few records and I would like to get its ID.

What i want to extract.

If I have 2 records in collection. Each of them has 2 tables which has additional 3 records.

I want to merge IDs of those records and put into another collection.

So 2 x 3 = 6 Record IDs in total.

Plz guide.

Thanks.

[v-xiaochen-msft · Accepted solution]

Hi @Ethan_R ,

Is this what you want?

1\ This is my original collection 'Col'.

2\ Add a button control and set its onselect property to:

ClearCollect(Col2,Ungroup(Col,"Notes"))

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[Ethan_R]

Thanks a lot @v-xiaochen-msft  !!!