Try...otherwise is breaking my excel

[Radoslaw Poprawski]

Hi All,

I have a table that might not generate any data,
So I figured i put some error handling.

i used:

try #"Some Step" otherwise Table.FormList({"Please generate files first})

but regardless of i i use after otherwise (Table.fromAny, Table.FromRecord, etc) excel always crashes.

any idea what's going on?
Ill add that in PQ before loading into excel this works as intended.

 

[Radoslaw Poprawski]

up by one

 

[RoryA]

It's Table.FromList not Table.FormList

 

[Radoslaw Poprawski]

yeah, its not the case of wrong spelling(i misspelled in the post)
but in PQ this step always crashes my excel
regardless of the Table i created after "otherwise"

 

[Radoslaw Poprawski]

up