Find all the values in a collection Power Apps

(0) Share

Report

Posted on by KrishR

431

Hello Everyone,

I have a collection that consists of multiple values in it. Just one column with name "Value". I was able to get the first value using First(Collection).Value.

Looking for some help on how to get the 4th and 5th value? I would like to set a variable based on each value inside in collection.

Can anyone please help!

Thank you so much in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

TuongDoan 573 Moderator on at

Like (1)

Report

Use Index(Collection, 4) to retrieve 4th record

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs upwould be a great compliment!

Was this reply helpful? Yes No
Verified answer

Gochix 1,935 Moderator on at

Like (1)

Report
@KrishR ,
Looking for some help on how to get the 4th and 5th value? I would like to set a variable based on each value inside in collection.
Last(FirstN(Collection.Value, 5)).Value

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
AsherNg1990 41 on at

Like (0)

Report

I just wonder if the accepted answer of @Gochix is faster than @TuongDoan's solution. Is there a performance difference between these options?

I have a similar question about the difference between using Lookup() versus First(Filter())). Could someone enlighten me on which approach is the most efficient and reliable?

Was this reply helpful? Yes No