Power Query
Search…
published
Table
Table.Contains

Table.Contains

Indicates whether the specified record appears as a row in the table.
function (table as table, row as record, optional equationCriteria as nullable any) as logical

Description

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.

Category

Table.Membership

Examples

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
Copy link
On this page
Table.Contains
Description
Category
Examples