List.SingleOrDefault
Syntax
List.SingleOrDefault(list as list, optional default as any) as any
About
If there is only one item in the list list
, returns that item. If the list is empty, the function returns null unless an optional default
is specified. If there is more than one item in the list, the function returns an error.
Example 1
Find the single value in the list {1}.
Usage
List.SingleOrDefault({1})
Output
1
Example 2
Find the single value in the list {}.
Usage
List.SingleOrDefault({})
Output
null
Example 3
Find the single value in the list {}. If is empty, return -1.
Usage
List.SingleOrDefault({}, -1)
Output
-1