length() Function


length( array )

This function returns the number of elements in an array.

See also:

  • isnull(): Use this function to determine if the process variable or array contains null values.
  • count(): Use this function to include null elements in the number of elements in a process variable or array.


Keyword Type Description


Any Type Array

The array in which to calculate the number of elements.



Usage considerations

Null elements

This function does not count null elements.

For example, if used on a null result of a query from the Query Database Smart Service, the expression fails to evaluate and causes an error. To avoid an error, first check the result set for a null value using the isnull() function before attempting to count the result set using the length() function.


length({10, 20, 30}) returns 3

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible
Process Reports Compatible
Process Events Compatible
Open in Github Built: Fri, Jun 09, 2023 (03:19:59 PM)

On This Page