Type.TableRow

This function retrieves the row type of a specified table. The output is guaranteed to be of record type.

Syntax

Type.TableRow(table as type) as type

About

This function retrieves the row type of a specified table. The output is guaranteed to be of record type.

Explanation

Retrieve the type information for the rows of a basic table by utilizing Power Query. This can be achieved by defining a variable 'tableRowType' that is assigned the type of the table rows, which is a table containing one column called "Column1". Afterwards, the function Type.RecordFields() is used to obtain the output that displays the type information for the column "Column1" as [Type = any type, Optional = not optional].