Table.Range

About

Returns the specified number of rows from a table starting at an offset.

Syntax

Table.Range( table as table, offset as number, optional count as nullable number) as table  

Arguments

Argument Description
table Source table.
Offset Starting row offset.
optional count Optional number of rows to return. If count is not provided, all rows are returned starting from offset.

Remark

  • Table.Range is similar to List.Range but requires a table as input.

Example

Table.Range(Table.FromRecords({  

    [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  

      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  

      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  

      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  

}), 1, 2)  
CustomerID Name Phone
2 Jim 987-6543
3 Paul 543-7890