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.
1
Record.SelectFields( [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0] , {"Item", "Price"})
Copied!
[Item = "Fishing rod", Price = 100]
Previous
Record.ReorderFields
Next
Record.ToList
Copy link
Contents
Record.SelectFields
Description
Category
Examples