Record.Combine

Syntax

Record.Combine(records as list) as record

About

Combines the records in the given records. If the records contains non-record values, an error is returned.

Example 1

Create a combined record from the records.

Usage

Power Query M

Record.Combine({
    [CustomerID = 1, Name = "Bob"],
    [Phone = "123-4567"]
})

Output

[CustomerID = 1, Name = "Bob", Phone = "123-4567"]