List.Min
Syntax
List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any
About
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.
Example 1
Find the min in the list {1, 4, 7, 3, -2, 5}.
Usage
List.Min({1, 4, 7, 3, -2, 5})
Output
-2
Example 2
Find the min in the list {} or return -1 if it is empty.
Usage
List.Min({}, -1)
Output
-1
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for