Training
Module
Create and manage columns within a table in Microsoft Dataverse - Training
Learn how to create and manage table columns in Dataverse.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Table.HasColumns(table as table, columns as any) as logical
Indicates whether the table
contains the specified column(s), columns
. Returns true
if the table contains the column(s), false
otherwise.
Determine if the table has the column [Name].
Usage
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"
)
Output
true
Find if the table has the column [Name] and [PhoneNumber].
Usage
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"}
)
Output
false
Training
Module
Create and manage columns within a table in Microsoft Dataverse - Training
Learn how to create and manage table columns in Dataverse.
Documentation
Μάθετε περισσότερα σχετικά με τα εξής: Table.Column
Μάθετε περισσότερα σχετικά με τα εξής: Table.ToList
Table.AddColumn - PowerQuery M
Μάθετε περισσότερα σχετικά με τα εξής: Table.AddColumn