Table.HasColumns Function of Power Query

The Table.HasColumns function indicates whether the table contains the specified column(s). The function returns true if the table contains the column(s), false otherwise.

Syntax

Table.HasColumns(table as table, columns as any) as logical

Example: Check CustomerID is the column in the given table.

Power Query M

let
  MyTable = Table.FromRecords(
    {
      [CustomerID = 1, Name = "Ashish", Phone = "123-4567"], 
      [CustomerID = 2, Name = "Katrina", Phone = "987-6543"], 
      [CustomerID = 3, Name = "Alia", Phone = "543-7890"], 
      [CustomerID = 4, Name = "Vicky", Phone = "676-8479"], 
      [CustomerID = 5, Name = "Mohini", Phone = "574-8864"], 
      [CustomerID = 6, Name = "Meenakshi", Phone = "574-8864"], 
      [CustomerID = 7, Name = "Esha", Phone = "574-8864"], 
      [CustomerID = 8, Name = "Anjali", Phone = "574-8864"]
    }
  ),
    Return = Table.HasColumns(MyTable, "CustomerID")
in
    Return

The output of the above function is true, because the column CustomerID is available in the given table.