Skip to main content

List.Min

Returns the minimum value or the default value for an empty list.

Syntax

List.Min(
list as list,
optional default as any,
optional comparisonCriteria as any,
optional includeNulls as logical
) as any

Remarks

Returns the minimum item in the list list, or the optional default value default if the list is empty. An optional comparisonCriteria value, comparisonCriteria, may be specified to determine how to compare the items in the list. If this parameter is null, the default comparer is used.

Examples

Example #1

Find the min in the list {1, 4, 7, 3, -2, 5}.

List.Min({1, 4, 7, 3, -2, 5})

Result:

-2

Example #2

Find the min in the list {} or return -1 if it is empty.

List.Min({}, -1)

Result:

-1

Category

List.Ordering