topic Re: Generating errors in #table code in Power Query

Generating errors in #table code

Mederic — Sat, 01 Jul 2023 20:46:15 GMT

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

Re: Generating errors in #table code

ronrsnfld — Sun, 02 Jul 2023 00:24:03 GMT

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

Re: Generating errors in #table code

Mederic — Sun, 02 Jul 2023 04:25:16 GMT

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