Training
Module
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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Table.SplitAt(table as table, count as number) as list
Returns a list containing two tables: a table with the first N rows of table
(as specified by count
) and a table containing the remaining rows of table
. If the tables of the resulting list are enumerated exactly once and in order, the function will enumerate table
only once.
Return the first two rows of the table and the remaining rows of the table.
Usage
Table.SplitAt(#table({"a", "b", "c"}, {{1, 2, 3}, {4, 5, 6}, {7, 8, 9}}), 2)
Output
{
#table({"a", "b", "c"}, {{1, 2, 3}, {4, 5, 6}}),
#table({"a", "b", "c"}, {{7, 8, 9}})
}
Training
Module
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.
Documentation
Table.SplitColumn - PowerQuery M
Learn more about: Table.SplitColumn
Table.ToColumns - PowerQuery M
Learn more about: Table.ToColumns
Learn more about: Table.ToRows