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
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: https://aka.ms/ContentUserFeedback.
Submit and view feedback for