How to get a default value (zero) when Table.SelectRows doesn't return a value

[LotteLaugesen]

Hi

Is there a way to return zero when [order number] isn't present in FT_table?
Here is my query:
(let currentOrder = [order number] in Table.SelectRows(FT_Table, each [order number] = currentOrder)){0}[SupplierID]

BR

Lotte

[LotteLaugesen · Accepted solution]

Found a solution - replace error...

[LotteLaugesen · Accepted solution]

Found a solution - replace error...

[AlexisOlson · Accepted solution]

It's generally better to handle the errors rather than replace them.

Try this:

let
    currentOrder = [order number],
    filteredTable = Table.SelectRows(FT_Table, each [order number] = currentOrder))
in
    try filteredTable{0}[SupplierID] otherwise 0

[LotteLaugesen]

Thank you so much 😊