cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Display Data from multi level collection

@ericonline 

Just as a little example...

//Simple ForAll
CountRows(ForAll([1,2,3,4,5], Value)) = 5
First(ForAll([1,2,3,4,5], Value)).Value = 1
Last(ForAll([1,2,3,4,5], Value)).Value = 5
//ForAll to make records
CountRows(ForAll([1,2,3,4,5], {myVal:Value})) = 5
First(ForAll([1,2,3,4,5], {myVal:Value})).myVal = 1
//A little more structure
Last(
First(
ForAll([1,2,3,4,5],
{myVal:Value,
myTab:ForAll([10,20,30,40], Value)
}
)
).myTab).Value = 40

They're not all that complex to deal with, but one must remember...there are not For Next loops!!  They are data iterations.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,857)