Type.ForRecord

Syntax

Type.ForRecord(fields as record, open as logical) as type

About

Gibt einen Typ zurück, der Datensätze mit bestimmten Typeinschränkungen für Felder darstellt.

Beispiel

Dynamisches Generieren eines Tabellentyps.

Verwendung

let
    columnNames = {"Name", "Score"},
    columnTypes = {type text, type number},
    rowColumnTypes = List.Transform(columnTypes, (t) => [Type = t, Optional = false]),
    rowType = Type.ForRecord(Record.FromList(rowColumnTypes, columnNames), false)
in
    #table(type table rowType, {{"Betty", 90.3}, {"Carl", 89.5}})

Output

#table(
    type table [Name = text, Score = number],
    {{"Betty", 90.3}, {"Carl", 89.5}}
)