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