cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sivaprasad21
Frequent Visitor

How to fetch multiple nested collection records?

Hi I have a collection taskdetails, which has a nested table checklist which has another nested table value that has two fields isChecked and title.

 

1. taskdetails

 

1.PNG

 

 

2. checklist

 

2.PNG

 

 

3a. value

3.PNG

 

3b. 

4.PNG

 

 

Need to bring all the value records into a new collection as shown below

 

isChecked | title

---------------------

False         | Restock Butter

False         | Refill strawberry

 

Thanks in advance for advice.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Sivaprasad21,

Do you want to access the nested table in the collection and collect them into a new collection?

Could you please share a bit more about the scenario, do you want to collect all the records in the value nested table?

Also, tell me that how you created your collection, post your formula.

Luka84 has a same problem with you, please check my answer as below:

Solved: Re: Extract Nested Collection - Power Platform Community (microsoft.com)

In a word, you just need to ForAll twice as below:

ForAll(
    taskdetails,
    ForAll(
        checklist.Value,
        Collect(
            Testttt,
            {
                isChecked1: Value.isChecked,
                title2: Value.title
            }
        )
    )
)

Hope it could help.

Regards,

Qi

Best Regards,
Qi

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

Hi @Sivaprasad21,

Do you want to access the nested table in the collection and collect them into a new collection?

Could you please share a bit more about the scenario, do you want to collect all the records in the value nested table?

Also, tell me that how you created your collection, post your formula.

Luka84 has a same problem with you, please check my answer as below:

Solved: Re: Extract Nested Collection - Power Platform Community (microsoft.com)

In a word, you just need to ForAll twice as below:

ForAll(
    taskdetails,
    ForAll(
        checklist.Value,
        Collect(
            Testttt,
            {
                isChecked1: Value.isChecked,
                title2: Value.title
            }
        )
    )
)

Hope it could help.

Regards,

Qi

Best Regards,
Qi

View solution in original post

Thank you so much. It worked!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,510)