Indicates whether all of the specified records appear as rows in the table.
function (
table
as table,rows
as list, optionalequationCriteria
as nullable any) as logical
Indicates whether all the specified records in the list of records rows
, appear as rows 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 all the rows comparing only the column [CustomerID].
Table.ContainsAll( 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=1, Name="Bill"],[CustomerID=2, Name="Fred"]}, "CustomerID")
true
Determine if the table contains all the rows.
Table.ContainsAll( 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=1, Name="Bill"],[CustomerID=2, Name="Fred"]})
false