List.Range

Returns a subset of the list beginning at an offset.

Syntax

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

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

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

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

Result:

{7, 8, 9, 10}

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

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

Result:

{7, 8}