Table.Range
Returns the rows beginning at the specified offset.
function (table
as table,offset
as number, optionalcount
as nullable any) as table
Returns the rows from the
table
starting at the specified offset
. An optional parameter, count
, specifies how many rows to return. By default, all the rows after the offset are returned.Table.Row operations
Return all the rows starting at offset 1 in the table.
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)
Table.FromRecords({[CustomerID=2,Name="Jim",Phone="987-6543"],[CustomerID=3,Name="Paul",Phone="543-7890"], [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]})
Return one row starting at offset 1 in the table.
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, 1)
Table.FromRecords({[CustomerID=2,Name="Jim",Phone="987-6543"]})
Last modified 4yr ago