List.Range

Syntax

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

About

Returns a subset of list beginning at offset. An optional parameter, count, 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}