List.Skip Function in Power Query

The List.Skip function returns a list after skipping the first count of items of the given list.

Syntax

List.Skip(list as list, optional countOrCondition as any) as list

The function has the following parameters:
• list: Input list from which we want to skip the items.
• countOrCondition: It is an optional parameter. It specifies the count of items to skip in given list. If a condition is specified, any consecutive matching items at the start of list are skipped. If it is omitted, by default first item in the list is skipped.

Note: If the given list is empty, it returns an empty list.

Example: Skip the first item in the given list. In this example, we have not specified the countOrCondition parameter.

Power Query M

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

The output of the above code is shown below:

Example: Return a list after skipping the first 2 items of the list.

Power Query M

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

The output of the above code is shown below:

Example:

Power Query M

let
  source = {"India", "America", "Canada", "Japan", "Australia", "England"}, 
  return = List.Skip(source, each let a= Text.Upper(_) in Text.Contains(a, "I"))
in
  return

The output of the above code is shown below:

Previous Next