← Back to Record functions

Record.AddField

This function will append a new field to a specific record. It requires the field name (fieldName) and the corresponding value (value) to be provided as parameters.

Syntax

Record.AddField(record as record, fieldName as text, value as any, optional delayed as nullable logical) as record

About

This function will append a new field to a specific record. It requires the field name (fieldName) and the corresponding value (value) to be provided as parameters.

Explanation

Include the Address field in the record using Power Query function MRecord.AddField() with the values of CustomerID, Name, and Phone. Set the Address field value to "123 Main St.". The output will show the updated record with the Address field included.