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 a new table type with the partition key replaced by the specified partition key.

Returns the type of a column in a table.

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

Returns the partition key for the given table type if it has one.

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.