Subscribe

UiPath Apps

The UiPath Apps Guide

Function: Filter

📘

Tip:

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

Use this function to filter a table based on its fields.

This function performs a case insensitive check.

Syntax

Description

Example

Filter(Entity, Condition)

The function returns all records that result in true. These expressions can reference fields/columns by name.

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

📘

Tip:

You can use more than one condition using the Filter function. To do so, use the following syntax:
Filter(Entity, [Condition 1], [Condition 2], [Condition 3]).

Example

Filter(Customer, [City, "=", New York]): The loaded table only displays the information for customers from the city of New York

Updated 3 months ago

Function: Filter


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.