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.

Table.FromValue(1)
Value
1

Example 2

Create a table from the list.

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

Example 3

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

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