Power Query
published
Search
⌃K

Record.HasFields

Record.HasFields

Indicates whether the record has the specified fields.
function (record as record, optional fields as nullable any) as logical

Description

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.

Category

Record.Information

Examples

Check if the record has the field "CustomerID".
Record.HasFields([CustomerID = 1, Name = "Bob", Phone = "123-4567"],"CustomerID")
true
Check if the record has the field "CustomerID" and "Address".
Record.HasFields([CustomerID = 1, Name = "Bob", Phone = "123-4567"],{"CustomerID", "Address"})
false