Type.ForRecord

This function generates a data type that defines records with specific requirements for field types.

Generate a table with specified columns and data types using Power Query. Specify column names and types, then transform them into a format suitable for creating a record type. Finally, create a table with the defined row type and input data. Resulting table will have columns "Name" with text type and "Score" with number type, containing data for "Betty" with score 90.3 and "Carl" with score 89.5.