List.Last

Syntax

List.Last(list as list, optional defaultValue as any) as any 

About

Returns the last item in the list list, or the optional default value, defaultValue, if the list is empty. If the list is empty and a default value is not specified, the function returns null.

Example 1

Find the last value in the list {1, 2, 3}.

List.Last({1, 2, 3})

3

Example 2

Find the last value in the list {} or -1 if it empty.

List.Last({}, -1)

-1