MissingField.Type

Updated on

MissingField.Type specifies the expected action for missing values in a row that contains columns less than expected.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the MissingField.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

ArgumentValueDescription
MissingField.Error0An optional parameter in record and table functions indicating that missing fields should result in an error. (This is the default parameter value.)
MissingField.Ignore1An optional parameter in record and table functions indicating that missing fields should be ignored.
MissingField.UseNull2An optional parameter in record and table functions indicating that missing fields should be included as null values.

Applies to

Here’s a list of functions that work with MissingField.Type:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/missingfield-type