Power Query
published
Search
⌃K

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].
Type.RecordFields(type [ A = number, optional B = any])
[ A = [Type = type number, Optional = false], B = [Type = type any, Optional = true] ]