Table.FromValue
Creates a table with a column from the provided value(s).
function (optionalvalue
as nullable any, optionaloptions
as nullable record) as table
Creates a table with a column containing the provided value or list of values,
value
. An optional record parameter, options
, may be specified to control the following options: Table.Table construction
Create a table from the value 1.
Table.FromValue(1)
Table.FromRecords({ [ Value = 1 ] })
Create a table from the list.
Table.FromValue({1, "Bob", "123-4567"})
Table.FromRecords({[ Value = 1 ], [Value = "Bob"], [Value="123-4567"]})
Create a table from the value 1, with a custom column name.
Table.FromValue(1, [DefaultColumnName = "MyValue"])
Table.FromRecords({ [ MyValue = 1 ] })
Last modified 4yr ago