CollectionLookup Function

The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression.

CollectionLookup(collection, returnField, filter)

Arguments:

collection

Collection - A collection.

returnField

Field - The field to return.

filter

FilterExpression - The filter criteria.

The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression.

CollectionLookup(collection, returnExpression, filter)

Arguments:

collection

Collection - A collection.

returnExpression

Any - An expression that resolves to the return value.

filter

FilterExpression - The filter criteria.

The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression.

CollectionLookup(collection, returnField, filter, default)

Arguments:

collection

Collection - A collection.

returnField

Field - The field to return.

filter

FilterExpression - The filter criteria.

default

Any - The default return value if no members match the filter criteria.

The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression.

CollectionLookup(collection, returnExpression, filter, default)

Arguments:

collection

Collection - A collection.

returnExpression

Any - An expression that resolves to the return value.

filter

FilterExpression - The filter criteria.

default

Any - The default return value if no members match the filter criteria.