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

Function: Sort

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

Use this function to sort the information from a source based on its fields.

Attention:

This function performs a case insensitive check.

Syntax

Description

Example

Sort(Source, [Field, SortOrder], ...)

Sorts the rows of a given array or range by the values in one or more columns.

docs image

Arguments

Argument

Type

Description

Source

Required

The table, array, or Entity to search (for example, a control's data property or the result of a process).

Field

Required

The field by which to sort. It is mandatory if the source list contains complex objects. For common types (number, string, date etc), the field should not be specified. Multiple fields can be specified.

SortOrder

Required

Choose between Ascending/ASC or Descending/DESC.
By default, the value is ASC.

Example

  • Sort(Customer, Name): Sort customers from a table by name (ascending order by default since no other value is given).
  • Sort(Customer, City, Age): Sort customers from a table by city and age (ascending order by default since no other value is given).
  • Sort(Customer, City, ”DESC”, Age): Sort customers from a table by city in a descending order, and by age in an ascending order.
  • Sort(Customer, City, ”ASC”, Age, “DESC”): Sort customers from a table by city in a ascending order, and by age in an descending order.
  • Arguments
  • Example

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.