List.Min
List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any
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.
Find the min in the list {1, 4, 7, 3, -2, 5}.
Usage
List.Min({1, 4, 7, 3, -2, 5})
Output
-2
Find the min in the list {} or return -1 if it is empty.
Usage
List.Min({}, -1)
Output
-1