apps
latest
false
- Getting Started
- Demo apps
- How To
- Build Your First App
- Build a Mobile-Friendly App
- General User Experience Guidelines
- Use Master Detail View
- Use Document Viewer
- Use Count With Choice Set Values
- Use Selected Values From a Table
- Embed Apps
- Embed Maps
- Hide Containers Using a Button
- Include MailTo Links
- Include Star Ratings
- Set External Context
- Work With Data Source and Value Bind
- Use the Send Interim Result Activity
- Public Apps
- Notifications
- Using VB Expressions
- Designing your App
- Events and Rules
- Rule: If-Then-Else
- Rule: Open a Page
- Rule: Open URL
- Rule: Close Pop-Over/Bottom Sheet
- Rule: Show Message
- Rule: Show/Hide Spinner
- Rule: Set Values
- Rule: Start Process
- Rule: Upload File to Storage Bucket
- Rule: Get File From Storage Bucket
- Rule: Reset Values
- Rule: Create/Update Entity Record
- Rule: Delete Entity Record
- Rule: Add to Queue
- Function: And, Or, Not
- Function: Concat
- Function: Contains
- Function: Count
- Function: EndsWith
- Function: If
- Function: IsBlank
- Function: Guid
- Function: Length
- Function: List
- Function: StartsWith
- Function: Sum
- Function: Sort
- Function: Now
- Function: Today
- Function: Time
- Function: Year
- Function: Month
- Function: Day
- Function: Hour
- Function: Minute
- Function: New
- Function: Lookup
- Function: Filter
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Leveraging Media in your app
- Leveraging Actions in your app
- Leveraging Connections in your apps
- Application Lifecycle Management (ALM)
- UiPath First-Party Apps
- Basic Troubleshooting Guide
LEGACY
Apps User Guide
Last updated Aug 5, 2024
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. |
|
|
Argument |
Type |
Description |
|---|---|---|
|
|
Required |
The entity to search (for example, a control's data property or the result of a process). |
|
|
Required |
The condition used to lookup for in the entity. The format for the
Condition argument should be as follows:
The following operators can be used:
|
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]).
