Table.FromRecords – สร้างตารางจากรายการ Record

let
    Source = Table.FromRecords({
        [ID = 1, Name = "Alice", Sales = 500],
        [ID = 2, Name = "Bob", Sales = 750],
        [ID = 3, Name = "Charlie", Sales = 600]
    })
in
    Source

let
    Source = Table.FromRecords({
        [ID = 1, Name = "Alice"],
        [ID = 2, Name = "Bob"]
    }, type table [Name = text, ID = number])
in
    Source

let
    Source = Table.FromRecords({
        [CustomerID = 1, FirstName = "Alice", Email = "alice@company.com"],
        [CustomerID = 2, FirstName = "Bob"],
        [CustomerID = 3, FirstName = "Charlie", Email = "charlie@company.com"]
    },
    type table [CustomerID = number, FirstName = text, Email = text],
    MissingField.UseNull)
in
    Source

let
    JsonData = Json.Document(Web.Contents("https://api.example.com/users")),
    RecordsList = JsonData[data],
    Table = Table.FromRecords(
        RecordsList,
        type table [id = number, username = text, email = text],
        MissingField.UseNull
    )
in
    Table