Record.HasFields
Whether a record has a field of a given name, or every one of several names.
Group: Record. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Record.HasFields(record as record, fields as any) as logical| Parameter | Type | Description |
|---|---|---|
record | record | The record to work on. |
fields | any | A field name, or a list of them. |
Returns
logical. true when every name is a field of the record.
Examples
One name
Record.HasFields([Order = 1001, Shop = "Oslo"], "Shop")trueAll of several names
Record.HasFields([Order = 1001, Shop = "Oslo"], {"Shop", "Discount"})falseDiscount is missing, so the answer is false.