הדרכה
מודול
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.
הדפדפן הזה אינו נתמך עוד.
שדרג ל- Microsoft Edge כדי לנצל את התכונות, עדכוני האבטחה והתמיכה הטכנית העדכניים ביותר.
Table.ContainsAny(table as table, rows as list, optional equationCriteria as any) as logical
Indicates whether any the specified records in the list of records rows
, appear as rows in the table
. An optional parameter equationCriteria
may be specified to control comparison between the rows of the table.
Determine if the table ({[a = 1, b = 2], [a = 3, b = 4]})
contains the rows [a = 1, b = 2]
or [a = 3, b = 5]
.
Usage
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 2],
[a = 3, b = 5]
}
)
Output
true
Determine if the table ({[a = 1, b = 2], [a = 3, b = 4]})
contains the rows [a = 1, b = 3]
or [a = 3, b = 5]
.
Usage
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 3],
[a = 3, b = 5]
}
)
Output
false
Determine if the table (Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4]}))
contains the rows [a = 1, b = 3]
or [a = 3, b = 5]
comparing only the column [a].
Usage
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 3],
[a = 3, b = 5]
},
"a"
)
Output
true
הדרכה
מודול
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.