Comment on page
Table.Contains
Indicates whether the specified record appears as a row in the table.
function (table
as table,row
as record, optionalequationCriteria
as nullable any) as logical
Indicates whether the specified record,
row
, appears as a row in the table
. An optional parameter equationCriteria
may be specified to control comparison between the rows of the table.Table.Membership
Determine if the table contains the row.
Table.Contains(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="Bob"])
true
Determine if the table contains the row.
Table.Contains(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="Ted"])
false
Determine if the table contains the row comparing only the column [Name].
Table.Contains(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"]}), [CustomerID=4, Name="Bob"], "Name")
true
Last modified 5yr ago