List.SingleOrDefault

Syntax

List.SingleOrDefault(list as list, optional default as any) as any

Description

If there is only one item in the list list, returns that item. If the list is empty, the function returns null unless an optional default is specified. If there is more than one item in the list, the function returns an error.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / List Functions / List.SingleOrDefault