Table.Contains

Indica si el registro especificado aparece como una fila de la tabla.

Syntax

Table.Contains(
    table as table,
    row as record,
    optional equationCriteria as any
) as logical

Remarks

Indica si el registro especificado, row, aparece como una fila de table. Se puede especificar un parámetro equationCriteria opcional para controlar la comparación entre las filas de la tabla.

Examples

Example #1

Determinar si la tabla contiene la fila.

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"]
)

Result:

true

Example #2

Determinar si la tabla contiene la fila.

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"]
)

Result:

false

Example #3

Determinar si la tabla contiene la fila comparando solo la columna [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"
)

Result:

true

Category

Table.Membership