List.Range

Syntax

List.Range(list as list, offset as number, optional count as nullable number) as list

About

Returns a subset of the list beginning at the offset list. An optional parameter, offset, sets the maximum number of items in the subset.

Example 1

Find the subset starting at offset 6 of the list of numbers 1 through 10.

Usage

List.Range({1..10}, 6)

Output

{7, 8, 9, 10}

Example 2

Find the subset of length 2 from offset 6, from the list of numbers 1 through 10.

Usage

List.Range({1..10}, 6, 2)

Output

{7, 8}