Power Query
published
Search
⌃K

List.First

List.First

Returns the first value of the list or the specified default if empty.
function (list as list, optional defaultValue as nullable any) as nullable any

Description

Returns the first item in the list list, or the optional default value, defaultValue, if the list is empty. If the list is empty and a default value is not specified, the function returns null.

Category

List.Selection

Examples

Find the first value in the list {1, 2, 3}.
List.First({1, 2, 3})
1
Find the first value in the list {}. If the list is empty, return -1.
List.First({}, -1)
-1