getCollectionItem

Use the getCollectionItem function to extract one item from the collection in the position of the index value. If the position of the index value is out of bounds, no value will be returned.

getCollectionItem(Input Collection, Index)

• Input collection: The input collection to extract the item from.
• Index: The location of the item to be returned within the collection.

getCollectionItem example

In the following example, the formula queries the collection: [1, 2, 3, 4, 5] to return the value at index 0.

getCollectionItem([1, 2, 3, 4, 5], 0)

The formula returns 1.