function (table
as table, optionaloptions
as nullable record) as table
PromoteAllScalars
: If set to true
, all the scalar values in the first row are promoted to headers using the Culture
, if specified (or current document locale). For values that cannot be converted to text, a default column name will be used. Culture
: A culture name specifying the culture for the data.Table.FromRecords({[CustomerID = 1,Name = "Bob", Column3 = #date(1980,1,1)]})
Table.FromRecords({[1 = 1, Name = "Bob", #"1/1/1980" = #date(1980, 1, 1)]})