Forum Discussion

Omid_Motamedise's avatar
Omid_Motamedise
Super User
2 years ago
Solved

Iserror in Power

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...
Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    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

m_dekorte's avatar
m_dekorte
Resident Rockstar
2 years ago

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