Share via

Record.RemoveFields

  • Article

Syntax

Record.RemoveFields(record as record, fields as any, optional missingField as nullable number) as record

About

Returns a record that removes all the fields specified in list fields from the input record. If the field specified does not exist, an exception is thrown.

Example 1

Remove the field "Price" from the record.

Usage

Power Query M 
Record.RemoveFields([CustomerID = 1, Item = "Fishing rod", Price = 18.00], "Price")

Output

[CustomerID = 1, Item = "Fishing rod"]

Example 2

Remove the fields "Price" and "Item" from the record.

Usage

Power Query M 
Record.RemoveFields([CustomerID = 1, Item = "Fishing rod", Price = 18.00], {"Price", "Item"})

Output

[CustomerID = 1]