Table.FromValue

Syntax

Table.FromValue(value as any, optional options as nullable record) as table  

About

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.

Example 1

Create a table from the value 1.

Usage

Power Query M

Table.FromValue(1)

Output

Table.FromRecords({[Value = 1]})

Example 2

Create a table from the list.

Usage

Power Query M

Table.FromValue({1, "Bob", "123-4567"})

Output

Power Query M

Table.FromRecords({
    [Value = 1],
    [Value = "Bob"],
    [Value = "123-4567"]
})

Example 3

Create a table from the value 1, with a custom column name.

Usage

Power Query M

Table.FromValue(1, [DefaultColumnName = "MyValue"])

Output

Table.FromRecords({[MyValue = 1]})