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
Record.AddField
Record.Combine
Record.Field
Record.FieldCount
Record.FieldNames
Record.FieldOrDefault
Record.FieldValues
Record.FromList
Record.FromTable
Record.HasFields
Record.RemoveFields
Record.RenameFields
Record.ReorderFields
Record.SelectFields
Record.ToList
Record.ToTable
Record.TransformFields
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Record.SelectFields

Record.SelectFields

Returns a record that contains only the specified fields.
function (record as record, optional fields as nullable any, optional missingField as nullable any) as record

Description

Returns a record which includes only the fields specified in list fields from the input record.

Category

Record.Selection

Examples

Select the fields "Item" and "Price" in the record.
Record.SelectFields( [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0] , {"Item", "Price"})
[Item = "Fishing rod", Price = 100]
Previous
Record.ReorderFields
Next
Record.ToList
Last modified 3yr ago
Copy link
Outline
Record.SelectFields
Description
Category
Examples