Table.FromValue
Table.FromValue(value as any, optional options 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:
DefaultColumnName
: The column name used when constructing a table from a list or scalar value.
Create a table from the value 1.
Usage
Table.FromValue(1)
Output
Table.FromRecords({[Value = 1]})
Create a table from the list.
Usage
Table.FromValue({1, "Bob", "123-4567"})
Output
Table.FromRecords({
[Value = 1],
[Value = "Bob"],
[Value = "123-4567"]
})
Create a table from the value 1, with a custom column name.
Usage
Table.FromValue(1, [DefaultColumnName = "MyValue"])
Output
Table.FromRecords({[MyValue = 1]})