Tip:
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: containsnot containsstartswithendswith=!=><>=<=innot in |
Tip:
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]).
Updated 6 months ago