← Back to Table functions

Table.ColumnNames

Returns a list of text that represents the names of the columns in the specified table.

Syntax

Table.ColumnNames(table as table) as list

About

Returns a list of text that represents the names of the columns in the specified table.

Explanation

Retrieve the names of the columns in the table by using the Power Query MTable.ColumnNames() function. The table consists of records with fields such as CustomerID, Name, and Phone, each corresponding to a different customer. The function returns an output showing the column names as {"CustomerID", "Name", "Phone"}.