Función Distinct de PowerAppsDistinct function in PowerApps

Resume los registros de una tabla, quitando los duplicados.Summarizes records of a table, removing duplicates.

DescripciónDescription

La función Distinct evalúa una fórmula en cada uno de los registros de una tabla.The Distinct function evaluates a formula across each record of a table. Distinct genera una tabla de una columna que contiene los resultados, sin los valores duplicados.Distinct returns a one-column table that contains the results, with duplicate values removed.

Fields of the record currently being processed are available within the formula. You simply reference them by name as you would any other value. You can also reference control properties and other values from throughout your app. For more details, see the examples below and working with record scope.

SintaxisSyntax

Distinct( Table, Formula )Distinct( Table, Formula )

  • Table: requerido.Table - Required. Tabla en la cual se realizará la evaluación.Table to evaluate across.
  • Formula: requerido.Formula - Required. La fórmula que se evalúa en cada registro.Formula to evaluate for each record.

EjemploExample

Si tuviera una tabla Employees con una columna Department, esta función mostraría el nombre de cada departamento único en esa columna, independientemente de cuántas veces apareció cada nombre en esa columna:If you had an Employees table that contained a Department column, this function would list each unique department name in that column, no matter how many times each name appeared in that column:

Distinct(Employees, Department)Distinct(Employees, Department)