Generating errors in #table code

[Mederic]

Hello, 

For my personal knowledge, I'd like to know if it's possible to add Errors in the code below as shown in the illustration on the right of the image?

Thanks in advance

Best regards

let
    T1 = #table( type table[C1=Text.Type, C2=Number.Type, C3=Number.Type, C4=Number.Type], { {"A",22, 36, 45}, {"B", 42, 54, 63}, {"C", 67, 73, 86}, {"D", 22, 76, 84}} )
in
    T1

[Mederic]

Hello @ronrsnfld ,

Great, thank you very much,
Thanks also for nice layout/formating the code
It's nicer and easier to read

Have a nice day

[ronrsnfld · Accepted solution]

Just replace any of the entries with an error record. You can add messages to the error which will show up if you select the cell. eg:

let
    T1 = #table( type table[C1=Text.Type, C2=Number.Type, C3=Number.Type, C4=Number.Type], { 
        {"A",22, 36, 45}, 
        {"B", 42, 54, 63}, 
        {"C", 67, 73, 86}, 
        {"D", 22, error [Reason="my error", Message="I want this", Detail="showing the error here"], 84}} )
in
    T1