View this page in the latest version of Appian. length() Function Share Share via LinkedIn Reddit Email Copy Link Print On This Page 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. Parameters Keyword Type Description array Any Type Array The array in which to calculate the number of elements. Returns Integer 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. Examples 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 Feedback Was this page helpful? SHARE FEEDBACK Loading...