Table of contents
TOC
Collapse the table of content
Expand the table of content

Record.TransformFields

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Transforms fields by applying transformOperations. For more more information about values supported by transformOperations, see Parameter Values.

Record.TransformFields(record as record,  transformOperations as list,  optional missingField as nullable number) as record  

Arguments

ArgumentDescription
recordThe Record to modify.
transformOperationsThe list of transformations to make.
optional missingFieldA MissingField enum value to handle missing fields. The default value is MissingField.Error.

MissingField enum

MissingField.Error = 0;  
MissingField.Ignore = 1;  
MissingField.UseNull = 2;  

Examples

Record.TransformFields([OrderID = 1, CustomerID= 1, Item = "Fishing rod", Price = "100.0"], {"Price", Number.FromText})  
equals [OrderID =1, CustomerID  =1, Item = "Fishing rod", Price=100 ]  
OrderID1
CustomerID1
ItemFishing rod
Price100
Record.TransformFields(  
[OrderID ="1", CustomerID= 1, Item = "Fishing rod", Price = "100.0"],  
{{"OrderID", Number.FromText}, {"Price",Number.FromText}})  
equals [OrderID =1, CustomerID  =1, Item = "Fishing rod", Price=100 ]  
OrderID1
CustomerID1
ItemFishing rod
Price100
© 2018 Microsoft