power query custom data type

[Dicken]

Hi, 

using the ui  create data type or Combine as record ;  

= Table.CombineColumnsToRecord(#"Changed Type", "Data type", {"Name", "Item"}, [DisplayNameColumn="Name", TypeName="Excel.DataType"])

i have watched a video where a table using this was loaded to execl as a table and then excel was able to detect the types created just the same as  those inbuilt such as countries.   I'm  on 365 home,  the video  was  
BCTI ; Microsoft Excel - Create Custom Data Types with (Excel's) Power Query  ,
i don't know whether i'm just doing somethin wrong, or it's down to my xl version. 

Richad.

[m_dekorte]

Hi @Dicken 

Your code looks syntactically valid. However I can't validate any named columns or step.
Are you seeing an error?

You can always try this to determine if your Power Query engine supports a function.
Create a new blank query, enter this code in the formula bar (without parenthesis).
= Table.CombineColumnsToRecord

Can you go to the File menu > Account and share the Excel version you are using?

[Dicken]

office 365 personal / home.

[m_dekorte]

Yes, but can you share the version and build number?

Thanks!

[Dicken]

sorry yes, 
Microsoft 365 MSO (Version 2603 Build 16.0.19822.20086) 64-bit
if you reply, may not get back to you until later today.