function (tables
as list, optionalcolumns
as nullable any) as table
tables
. The resulting table will have a row type structure defined by columns
or by a union of the input types if columns
is not specified.Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=2,Name="Jim",Phone="987-6543"],[CustomerID=3,Name="Paul",Phone="543-7890"]})
Table.FromRecords({[Name="Bob",Phone="123-4567",Fax=null,Cell=null],[Name=null,Phone="838-7171",Fax="987-6543",Cell=null],[Name=null,Phone=null,Fax=null,Cell="543-7890"]})
Table.FromRecords({[CustomerID=null,Name="Bob"],[CustomerID=null,Name=null],[CustomerID=null,Name=null]})