Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ToRows

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a nested list of row values from an input table.

Table.ToRows(table as table) as list  

Arguments

ArgumentDescription
tableThe Table to check.

Example

let  
  
    Source = Table.ToRows(Table.FromRecords({  
  
    [CustomerID =1, Name ="Bob", Phone = "123-4567"],  
  
    [CustomerID =2, Name ="Jim", Phone = "987-6543"],  
  
    [CustomerID =3, Name ="Paul", Phone = "543-7890"]  
  
}))  
  
in  
  
    Source  
  
equals  
  
{  
  
    {1, "Bob", "123-4567"},  
  
    {2, "Jim", "987-6543"},  
  
    {3,  "Paul", "543-7890"}  
  
}  
© 2018 Microsoft