Table.Contains

Sintaxis

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

Acerca de

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.

Ejemplo 1

Determinar si la tabla contiene la fila.

Uso

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

Salida

true

Ejemplo 2

Determinar si la tabla contiene la fila.

Uso

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

Salida

false

Ejemplo 3

Determinar si la tabla contiene la fila comparando solo la columna [Name].

Uso

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

Salida

true