Type.ForRecord

Sintaxis

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

Acerca de

Devuelve un tipo que representa registros con restricciones de tipo específicas en campos.

Ejemplo

Genere dinámicamente un tipo de tabla.

Uso

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}})

Salida

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