Record.HasFields

Syntax

Record.HasFields(record as record, fields as any) as logical 

About

Indicates whether the record record has the fields specified in fields, by returning a logical value (true or false). Multiple field values can be specified using a list.

Example 1

Check if the record has the field "CustomerID".

Usage

Power Query M

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

Output

true

Example 2

Check if the record has the field "CustomerID" and "Address".

Usage

Power Query M

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

Output

false