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.ContainsAny(table as table, rows as list, optional equationCriteria as any) as logical
Angiver, om de angivne poster på listen over poster rows
vises som rækker i table
. Der kan angives en valgfri parameter equationCriteria
for at styre sammenligningen mellem rækkerne i tabellen.
Find ud af, om tabellen ({[a = 1, b = 2], [a = 3, b = 4]})
indeholder rækkerne [a = 1, b = 2]
eller [a = 3, b = 5]
.
Brug
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 2],
[a = 3, b = 5]
}
)
Output
true
Find ud af, om tabellen ({[a = 1, b = 2], [a = 3, b = 4]})
indeholder rækkerne [a = 1, b = 3]
eller [a = 3, b = 5]
.
Brug
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 3],
[a = 3, b = 5]
}
)
Output
false
Find ud af, om tabellen (Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4]}))
indeholder rækkerne [a = 1, b = 3]
, eller [a = 3, b = 5]
sammenlign kun kolonnen [a].
Brug
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 3],
[a = 3, b = 5]
},
"a"
)
Output
true
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.