Downloads
Power Query MTable: build and convertAdvanced

Table.FromList

Turns a list into a table with one column, or splits each item into several columns with a splitter.

Syntax
Table.FromList(list as list, optional splitter as nullable function, optional columns as any, optional default as any, optional extraValues as nullable number) as table

Returns: A new table built from the list.

What it does

Table.FromList turns a list into a table. With the splitter Splitter.SplitByNothing(), each item becomes one row in a single column. With a splitter for text, such as one that splits at a bar or a comma, each item is cut into several columns. It is the usual way to turn a list that a function produced into a table that the rest of the query can use.

Syntax and arguments

Example

A list of month-end dates is needed as a single column for a calendar lookup. Each date is one row in a column named Month end.

let
    MonthEnds = {#date(2026, 1, 31), #date(2026, 2, 28), #date(2026, 3, 31)},
    AsTable = Table.FromList(MonthEnds, Splitter.SplitByNothing(), {"Month end"}, null, ExtraValues.Error)
in
    AsTable

Each date becomes a row, in one column called Month end. The list is not split, because each item is a single value.

Example: a second, different use

A list of account codes and names is written as "1000|Cash". Each item is split at the bar into two columns, Account and Name.

let
    Pairs = {"1000|Cash", "1100|Receivables", "2000|Payables"},
    Split = Table.FromList(Pairs, Splitter.SplitTextByDelimiter("|"), {"Account", "Name"}, null, ExtraValues.Error)
in
    Split

Things to watch

In business terms

Lists of dates, codes and references are produced by many functions in a query. Turning them into a table lets them be joined, filtered and reported like any other data.

Related functions

All Power Query M functions · View as Markdown · M basics