Function: Lookup

Note: To better understand how the Lookup function works, check out the Using Apps with Data Service pages in the How To section.

Use this function to find and return the first record in a table that satisfies a formula or condition.

Syntax	Description	Example
Lookup(Entity, Condition)	Returns the first entity record that matches the condition.

Arguments

Argument	Type	Description
Entity	Required	The entity to search (for example, a control's data property or the result of a process).
Condition	Required	The condition used to lookup for in the entity. The format for the Condition argument should be as follows: [Entity Field, Operator, Value] The following operators can be used: contains not contains startswith endswith = != > < >= <= in not in

Note:

You can use more than one condition using the Lookup function. To do so, use the following syntax:

Lookup(Entity, [Condition 1], [Condition 2], [Condition 3]).