function (table
as table, optionalcolumns
as nullable any, optionalmissingField
as nullable any) as table
columns
from the table
provided. If the column doesn't exist, an exception is thrown unless the optional parameter missingField
specifies an alternative (eg. MissingField.UseNull
or MissingField.Ignore
).Table.FromRecords({[CustomerID=1,Name="Bob"]})
[Expression.Error] The field 'Address' of the record was not found.