Conditional Output

[PawelJanczak]

Greetings,

I'm working on a conditional output, that will swich output table (if it's empty) to the predefined one. The code goes as:

#"Filtered Rows4" = Table.SelectRows(#"Added Custom3", each ([Custom] = "Object missing")),
Test = Table.IsEmpty(#"Filtered Rows4"), // returns TRUE, as logical value type I guess
TestOKTable = Table.FromRecords({[Message = "OK"]}),
Output = (if Test = "TRUE" then TestOKTable else #"Filtered Rows4") //no matther what, always returns #"Filtered Rows4" with 0 rows
in
Output

I'm looking for a hint what am I doing wrong, tried the Output = (if Test = TRUE then TestOKTable else #"Filtered Rows4") but returns error, seems I'm not able to properly refer to the TRUE result.

EDIT: the solution was simple, to refer properly to logical value is was required to write the code as:

Output = (if Test = true then TestOKTable else #"Filtered Rows4") // lower case need to be used without quotation

Case resolved....

Would appreciate any feedback.

[artemus · Accepted solution]

You can simply this with just:

if Test then TestOKTable else #"Filtered Rows4"