Record.FieldOrDefault

Syntax

Record.FieldOrDefault(record as nullable record, field as text, optional defaultValue as any) as any

Description

Returns the value of the specified field field in the record record. If the field is not found, the optional defaultValue is returned.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Record Functions / Record.FieldOrDefault