web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to fetch multiple ...

Power Apps

Answered

How to fetch multiple nested collection records?

(0) Share

Report

Report

Posted on by Sivaprasad21

11

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

2. checklist

3a. value

3b.

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.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
Sivaprasad21 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much. It worked!

Join the conversation