lookup() Function

Function

lookup( multipleValues, dataToLookup, valueIfNotPresent )

Returns location of data within multiple values, or valueIfNotPresent.

Parameters

Keyword	Type	Description
multipleValues	Any Type	Values to lookup within.
dataToLookup	Any Type	Value to lookup within multipleValues.
valueIfNotPresent	Any Type	Value to return if dataToLookup is not present.

Returns

Integer

Usage considerations

Understanding the valueIfNotPresent parameter

The valueIfNotPresent parameter is always cast to an Integer before being returned. If the value you provide cannot be cast to an Integer, the function returns null instead.

For example, lookup({"a", "b", "c", "d"}, "q", "hi") returns null because "hi" cannot be cast to an Integer.

Examples

lookup({"a", "b", "c", "d"}, "c", -1) returns 3

Feature compatibility

The table below lists this function's compatibility with various features in Appian.

Feature	Compatibility	Note
Portals	Compatible
Offline Interfaces	Compatible
Sync-Time Custom Record Fields	Compatible	Can be used to create a custom record field that only evaluates at sync time.
Real-Time Custom Record Fields	Incompatible	Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.
Process Reports	Compatible
Process Events	Compatible	Can be used to configure a process event node, such as a start event or timer event.
Process Autoscaling	Compatible	Can be used in autoscaled processes.
Event Consumer Filter Conditions	Compatible	Can be used in filter conditions.
Event Consumer Event Handlers	Compatible	Can be used in event handler expressions.

Feedback