List.Single Function in Power Query

The List.Single function returns the single item of the list, when there is only one item in the list or throws an Expression.Error if the list has more than one item or the list is empty.

Syntax

List.Single(list as list) as any

Example: Find the single value in the list.

Power Query M

let
  source = {"Ashish"}, 
  return = List.Single(source)
in
    return

The output of the above code is “Ashish”.

Example: Find the single value in the given list.

Power Query M

let
  source = {"India", "America", "Canada", "Japan", "Australia", "England", "China"}, 
  return = List.Single(source)
in
  return

The output of the above code is shown below:

Previous Next