Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Record.AddField
Record.Combine
Record.Field
Record.FieldCount
Record.FieldNames
Record.FieldOrDefault
Record.FieldValues
Record.FromList
Record.FromTable
Record.HasFields
Record.RemoveFields
Record.RenameFields
Record.ReorderFields
Record.SelectFields
Record.ToList
Record.ToTable
Record.TransformFields
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Record.AddField

Record.AddField

Adds a field to a record.
function (record as record, fieldName as text, optional value as nullable any, optional delayed as nullable any) as record

Description

Adds a field to a record record, given the name of the field fieldName and the value value.

Category

Record.Transformations

Examples

Add the field Address to the record.
Record.AddField([CustomerID = 1, Name = "Bob", Phone = "123-4567"], "Address", "123 Main St.")
[CustomerID=1, Name= "Bob", Phone="123-4567", Address="123 Main St."]
Previous
Record
Next
Record.Combine
Last modified 3yr ago
Copy link
Outline
Record.AddField
Description
Category
Examples