Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Function.IsDataSource
Type.AddTableKey
Type.ClosedRecord
Type.Facets
Type.ForFunction
Type.ForRecord
Type.FunctionParameters
Type.FunctionRequiredParameters
Type.FunctionReturn
Type.Is
Type.IsNullable
Type.IsOpenRecord
Type.ListItem
Type.NonNullable
Type.OpenRecord
Type.RecordFields
Type.ReplaceFacets
Type.ReplaceTableKeys
Type.TableColumn
Type.TableKeys
Type.TableRow
Type.TableSchema
Type.Union
Uri
Values
Powered By GitBook
Type.RecordFields

Type.RecordFields

Returns a record describing the fields of a record type with each field of the returned record type having a corresponding name and a value.
function (type as type) as record

Description

Returns a record describing the fields of a record type. Each field of the returned record type has a corresponding name and a value, in the form of a record [ Type = type, Optional = logical ].

Category

Type

Examples

Find the name and value of the record [ A = number, optional B = any].
1
Type.RecordFields(type [ A = number, optional B = any])
Copied!
[ A = [Type = type number, Optional = false], B = [Type = type any, Optional = true] ]
Previous
Type.OpenRecord
Next
Type.ReplaceFacets
Last modified 3yr ago
Copy link
Contents
Type.RecordFields
Description
Category
Examples