Explore Record Functions in Power Query M Language, crucial for manipulating record data. This page provides a comprehensive list and descriptions of Record Functions available in the M Language.
Table of contents Creation and Conversion Functions
Function Description Input Output Record.FromList Returns a record given a list of field values and a set of fields. List Record Record.FromTable Creates a record from a table of the form {[Name = name, Value = value]}. Table Record Record.ToList Returns a list of values containing the field values of the input record. Record List Record.ToTable Returns a table with each row being a field name and value of the input record. Record Table
Geography and Geometry Functions
Function Description Input Output Geography.FromWellKnownText Translates text representing a geographic value in Well-Known Text (WKT) format into a structured record. Text Record Geography.ToWellKnownText Translates a structured geographic point value into its Well-Known Text (WKT) representation. Record Text GeographyPoint.From Creates a record representing a geographic point from parts. Number Record Geometry.FromWellKnownText Translates text representing a geometric value in Well-Known Text (WKT) format into a structured record. Text Record Geometry.ToWellKnownText Translates a structured geometric point value into its Well-Known Text (WKT) representation. Record Text GeometryPoint.From Creates a record representing a geometric point from parts. Number Record
Modification Functions
Selection Functions
Function Description Input Output Record.Field Returns the value of the specified field in a record. Record Any Record.FieldOrDefault Returns the value of the specified field in a record or the default value if the field is not found. Record Any Record.SelectFields Returns a record that contains only the specified fields. Record Record
