Forum Discussion
Solved
Generating errors in #table code
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
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
2 Replies
Replies have been turned off for this discussion
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