Forall on nested collection

(0) Share

Report

Posted on by Buddy2019

Using a forall() , I want to store all the MeetingA values inside a new collection. I tried the following but it doesn't work. How could I get all the meetingA values ?

ClearCollect(NewOrder, ForAll(CollectTest, {newTime:Meeting.Value.MeetingA}))

ClearCollect(
 CollectTest,
 {
 Id: 1,
 Meeting: [
 {
 MeetingA: "MeetingA1",
 B: "MeetingB1"
 },
 {
 MeetingA: "MeetingA2",
 B: "MeetingB2"
 }
 ]
 },
 {
 Id: 2,
 Meeting: [
 {
 MeetingA: "MeetingC",
 B: "MeetingD"
 }
 ]
 },
 {
 Id: 3,
 Meeting: [
 {
 MeetingA: "MeetingE",
 B: "MeetingF"
 }
 ]
 }
)

Thanks !

Categories:

Building Power Apps

All responses (1)

Answers (0)

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Buddy2019

There are two layers of tables in the collection you provided so a nested FORALL loop is necessary to get at the MeetingA values.

Here's my code:

ForAll( CollectTest, ForAll(Meeting.Value, Collect(colMeetingA,{newTime:Value.MeetingA}) ) );

The resulting Collection is:

"MeetingA1", "MeetingA2", "MeetingC", "MeetingE"

---
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."