Syntax Record.ToList(record as record) as list Description Returns a list of values containing the field values from the input record. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.ToList
Syntax Record.Combine(records as list) as record Description Combines the records in the given records. If the records contains non-record values, an error is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.Combine
Syntax Record.RenameFields(record as record, renames as list, optional missingField as nullable number) as record Description Returns a record after renaming fields in the input record to the new field names specified in list renames. For multiple renames, a nested list can be used ({ {old1,… Read More »Record.RenameFields
Syntax Record.FieldValues(record as record) as list Description Returns a list of the field values in record record. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.FieldValues
Syntax Record.ToTable(record as record) as table Description Returns a table containing the columns Name and Value with a row for each field in record. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.ToTable
Syntax Record.FromTable(table as table) as record Description Returns a record from a table of records table containing field names and value names {[Name = name, Value = value]}. An exception is thrown if the field names are not unique. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Record.FromTable
Syntax Record.FieldNames(record as record) as list Description Returns the names of the fields in the record record as text. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.FieldNames
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… Read More »Record.FieldOrDefault
Syntax Record.FromList(list as list, fields as any) as record Description Returns a record given a list of field values and a set of fields. The fields can be specified either by a list of text values, or a record type. An error is thrown if… Read More »Record.FromList
Syntax Record.Field(record as record, field as text) as any Description Returns the value of the specified field in the record. If the field is not found, an exception is thrown. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Record Functions / Record.Field