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
Solved! Go to Solution.
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."
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."
User | Count |
---|---|
252 | |
107 | |
89 | |
51 | |
44 |