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

Table.ToRows

Owen Duncan|Last Updated: 4/19/2018

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