Træning
Modul
Create formulas that use tables, records, and collections in a canvas app in Power Apps - Training
Do you have need for complex formulas in your app? This module can help you write those formulas.
Denne browser understøttes ikke længere.
Opgrader til Microsoft Edge for at drage fordel af de nyeste funktioner, sikkerhedsopdateringer og teknisk support.
Table.TransformRows(table as table, transform as function) as list
Opretter en list
ved at anvende handlingen transform
på hver række i table
.
Transformér rækkerne i en tabel til en liste over tal.
brug
Table.TransformRows(
Table.FromRecords({
[a = 1],
[a = 2],
[a = 3],
[a = 4],
[a = 5]
}),
each [a]
)
output
{1, 2, 3, 4, 5}
Transformér rækkerne i en numerisk tabel til tekstposter.
brug
Table.TransformRows(
Table.FromRecords({
[a = 1],
[a = 2],
[a = 3],
[a = 4],
[a = 5]
}),
(row) as record => [B = Number.ToText(row[a])]
)
output
{
[B = "1"],
[B = "2"],
[B = "3"],
[B = "4"],
[B = "5"]
}
Træning
Modul
Create formulas that use tables, records, and collections in a canvas app in Power Apps - Training
Do you have need for complex formulas in your app? This module can help you write those formulas.