List.Single
Syntax
List.Single(list as list) as any
About
If there is only one item in the list list
, returns that item. If there is more than one item or the list is empty, the function throws an exception.
Example 1
Find the single value in the list {1}.
Usage
List.Single({1})
Output
1
Example 2
Find the single value in the list {1, 2, 3}.
Usage
List.Single({1, 2, 3})
Output
[Expression.Error] There were too many elements in the enumeration to complete the operation.
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