Record.FromTable
This function retrieves a single record from a table of records. The record includes both field names and their corresponding values, represented as pairs like {[Name = name, Value = value]}. If dupli...
This function retrieves a single record from a table of records. The record includes both field names and their corresponding values, represented as pairs like {[Name = name, Value = value]}. If duplicate field names are found, an exception is generated.
Generate a data record using the table structure created by Table.FromRecords function. The record includes values for CustomerID, Name, and Phone fields. This can be achieved by using Power Query MRecord.FromTable function with the specified data values. The resulting output will be a record with fields CustomerID, Name, and Phone along with their respective values.