Answered

Nested collections to one table.

(0) Share

Report

Posted on by potrek

Hi all,

I have problem to put nasted collection data table2 and table3 into one table1. I would like to get results like shown in table4.

What is important data is not fixed, will change numbers of rows according to planner input.

i would just like to extract the assigned values, include them in one table and repeat the rest corresponding collumns for each.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @potrek

To help with this, I have some questions.

Are you trying to get data from all 4 tables into one collection?
What is your Data source?

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
potrek 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy ,
Thank You for Your reply!

1. Not. Table2 and Table3 (nasted tables) are included in Table1 as in schematic attached. I'm trying to get Table4 as a result as shown in picture attached.
2. Data source: Collect(planTasks; Planner.ListTasksV2(id).value);
See results below with reference to Table schematic from first post.

The main aim is to create Horrizontal Gallery1 with users assigned to tasks in rows and Perpanticular Gallery 2 included in Gallery1 to list tasks assigned to users in Gallery1.
It happend that some tasks are without assignments, in some are more than one users assigned.
all that informations are included in collumn _assignments according to Planner function ListTasksV2 but as nested table.
Hope it will help to find solution or to find other way to get what i need.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @potrek :

I've made a test for your reference:

1\My Source:

ClearCollect( Table1, {Column1:Table( {Collumn3:"Text2a",Column4:"Text"}, {Collumn3:"Text2b",Column4:"Text"} ), Column2:"TextRow1" }, {Column1:Table( {Collumn3:"Text3a",Column4:"Text"}, {Collumn3:"Text3b",Column4:"Text"}, {Collumn3:"Text3C",Column4:"Text"} ), Column2:"TextRow2" } )

2\Please try this code:

ShowColumns(Ungroup(Table1,"Column1"),"Collumn3","Column2")

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
potrek 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft
Bof... You are great man!
This is the function I was looking for... Simply but I missed it... Thank you so much for your help, it has allowed me to move on with my project.
I am very grateful!

Was this reply helpful? Yes No