Type functions
Type functions functions for Power Query M language.
Functions
| Function | Description |
|---|---|
| Type.AddTableKey | Inserts a new primary identifier into the specified table category. |
| Type.ClosedRecord | The specified type should be a record type that returns a closed version of the original record type. If the type is already closed, it will return the same type. |
| Type.Facets | The function retrieves a data set that includes the different categories of a specific type. |
| Type.ForFunction | Generates a function type based on its signature, which includes details about the return type, parameters, and the minimum number of arguments needed to call the function. |
| Type.ForRecord | This function generates a data type that defines records with specific requirements for field types. |
| Type.FunctionParameters | Returns a dataset containing the names of the parameters and their corresponding values, with the parameters being of a specific type. |
| Type.FunctionRequiredParameters | This function will return a numerical value that indicates the minimum number of parameters needed to call the specified type of function. |
| Type.FunctionReturn | Returns the data type that is returned by a specific function type. |
| Type.Is | This function checks whether a value of type1 can be used with type2 without any compatibility issues. |
| Type.IsNullable | This function indicates whether a specific type is nullable or not. It returns true for nullable types and false for non-nullable types. |
| Type.IsOpenRecord | Returns a Boolean value that indicates if a record type is currently active. |
| Type.ListItem | Retrieves the item type from a given list type. |
| Type.NonNullable | This function retrieves the type's non-nullable value. |
| Type.OpenRecord | This function will provide an opened version of the specified record type, or will return the same type if it is already open. |
| Type.RecordFields | The function returns a record that provides information about the fields of a specific record type. Each field in the returned record includes a name and a value, presented as a record in the format [... |
| Type.ReplaceFacets | Substitute the characteristics of the type with the characteristics found in the record facets. |
| Type.ReplaceTableKeys | Generates a new table type where all original keys are substituted with a designated list of keys. |
| Type.TableColumn | This function retrieves the data type of a specific column named "column" within the table called "tableType". |
| Type.TableKeys | This function retrieves a list of keys for the specified table type. The list may be empty. |
| Type.TableRow | This function retrieves the row type of a specified table. The output is guaranteed to be of record type. |
| Type.TableSchema | The function returns a table that provides information about the columns in the tableType. To understand more about the content of the table, please consult the documentation for Table.Schema. |
| Type.Union | This function will provide the combination of all the different types listed in the "types" parameter. |