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

Table.Group

Table.InsertRows

Last modified 4yr ago