Iserror in Power

[Omid_Motamedise]

As you know in power query there is try  (try-otherwise and try-catch which has been available since 2022) function to handle Error values.
I am asking in the Excel version, is there any function to handle logic like Iserror in Excel (receives an argument and returns true if the argument is an error).

[m_dekorte · Accepted solution]

Hi @Omid_Motamedise,

No, there are a limited number of functions in Power Query that can handle error values, for example Table.ReplaceErrorValues Table.RemoveRowsWithErrors and Table.SelectRowsWithErrors they are probably the most useful.

But that doesn't mean that we can't replicate the EXCEL IsError function's behavior, give this a go:

[
    expression = 1 + 1 /* "1" */,
    result = (try expression )[HasError]
][result]

I hope this is helpful

[Omid_Motamedise]

@m_dekorte Thank you.