Power Query
Search…
published
Table
Table.HasColumns

Table.HasColumns

indicates whether the table contains the specified column(s).
function (table as table, optional columns as nullable any) as logical

Description

indicates whether the table contains the specified column(s), columns. Returns true if the table contains the column(s), false otherwise.

Category

Table.Column operations

Examples

Determine if the table has the column [Name].
Table.HasColumns(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"], [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]}),"Name")
true
Find if the table has the column [Name] and [PhoneNumber].
Table.HasColumns(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"], [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]}),{"Name", "PhoneNumber"})
false
Copy link
On this page
Table.HasColumns
Description
Category
Examples