Type - Power Query

📄️ Type.AddTableKey

Adds a key to the given table type.

Returns a closed version of the given record type (or the same type, if it is already closed).

Returns the facets of a type.

Returns a type that represents functions with specific parameter and return type constraints.

Returns a type that represents records with specific type constraints on fields.

Returns a record with field values set to the name of the parameters of a function type, and their values set to their corresponding types.

Returns a number indicating the minimum number of parameters required to invoke the type of function.

Returns a type returned by a function type.

Determines if a value of the first type is always compatible with the second type.

Returns true if a type is a nullable type; otherwise, false.

Returns whether a record type is open.

Returns an item type from a list type.

Returns the non nullable type from a type.

Returns an opened version of the given record type (or the same type, if it is already open).

Returns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value.

Replaces the facets of a type.

Returns a new table type with all keys replaced by the specified list of keys.

Returns the type of a column in a table.

Returns the possibly empty list of keys for the given table type.

Returns the row type of the table type.

Returns a table containing a description of the columns (i.e. the schema) of the specified table type.

Returns the union of a list of types.