MissingField.Type - Enumeration

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).

Argument	Value	Description
MissingField.Error	0	An optional parameter in record and table functions indicating that missing fields should result in an error. (This is the default parameter value.)
MissingField.Ignore	1	An optional parameter in record and table functions indicating that missing fields should be ignored.
MissingField.UseNull	2	An 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