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.
1
Record.AddField([CustomerID = 1, Name = "Bob", Phone = "123-4567"], "Address", "123 Main St.")
Copied!
[CustomerID=1, Name= "Bob", Phone="123-4567", Address="123 Main St."]
Previous
Record
Next
Record.Combine
Copy link
Contents
Record.AddField
Description
Category
Examples