apps
2023.10
true
LEGACY
Legacy Apps User Guide for Automation Suite
Automation CloudAutomation Cloud Public SectorAutomation Suite
Last updated Jan 18, 2024

Function: Lookup

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.

docs image

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
  • Arguments

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.