Træning
Modul
Author a basic formula that uses tables and records in a Power Apps canvas app - Training
Learn how to author a basic formula that uses tables and records in a Power Apps canvas app.
Denne browser understøttes ikke længere.
Opgrader til Microsoft Edge for at drage fordel af de nyeste funktioner, sikkerhedsopdateringer og teknisk support.
Table.IsDistinct(table as table, optional comparisonCriteria as any) as logical
Angiver, om table
indeholder kun særskilte rækker (ingen dubletter). Returnerer true
, hvis rækkerne er entydige, false
ellers. En valgfri parameter angiver, comparisonCriteria
hvilke kolonner i tabellen der testes til duplikering. Hvis comparisonCriteria
ikke er angivet, testes alle kolonner.
Afgør, om tabellen er entydig.
Brug
Table.IsDistinct(
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"]
})
)
Output
true
Afgør, om tabellen er entydig i kolonnen.
Brug
Table.IsDistinct(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 5, Name = "Bob", Phone = "232-1550"]
}),
"Name"
)
Output
false
Træning
Modul
Author a basic formula that uses tables and records in a Power Apps canvas app - Training
Learn how to author a basic formula that uses tables and records in a Power Apps canvas app.