Table.FromValue

Table.FromValue

Creates a table with a column from the provided value(s).

function (optional value as nullable any, optional options as nullable record) as table

Description

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:

Category

Table.Table construction

Examples

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 ] })