cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mmattar Post Patron
Post Patron

Lookup a collection

Hello all,

 

I have a collection that holds up to at least 10 records, i need to lookup a row and grab a data from one column of that row and store it into a variable. This is possible with First and Last, but how do i get records that are the 2nd, 3rd, 4th etc..

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Lookup a collection

@mmattar 

To get a value from the 2nd row of a collection and store it in a variable you would do this

Set(myVariable, Last(FirstN(your_collection_name, 2)).your_fieldname)

 

To get a value from the 5th row of a collection and store it in a variable you would do this

Set(myVariable, Last(FirstN(your_collection_name, 5)).your_fieldname)

 

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

View solution in original post

1 REPLY 1
Super User
Super User

Re: Lookup a collection

@mmattar 

To get a value from the 2nd row of a collection and store it in a variable you would do this

Set(myVariable, Last(FirstN(your_collection_name, 2)).your_fieldname)

 

To get a value from the 5th row of a collection and store it in a variable you would do this

Set(myVariable, Last(FirstN(your_collection_name, 5)).your_fieldname)

 

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

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (9,174)