Type.ForRecord
Type.ForRecord(fields as record, open as logical) as type
Devuelve un tipo que representa los registros con restricciones de tipos específicas en los campos.
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}}
)