Power Query If condition error due to null field

[gigi79]

Hello all, I have a power query with an of condition that is shooting an error because the field in question is null.

Is there a way to show the error as null instead of error?

The current formula is: if product contains bill then yes else null.

For items where the product field is null it is showing error. I want it to show as null

Thanks in advance

 

[alansidman]

When you click on one of the error cells, what message do you get. We need to understand why you are getting an error and then fix the causation.

 

[gigi79]

When you click on one of the error cells, what message do you get. We need to understand why you are getting an error and then fix the causation.

I am getting the error on the items that have null for the product.

The error is “we cannot convert the value null to type logical”

 

[JGordon11]

Hello all, I have a power query with an of condition that is shooting an error because the field in question is null.

Is there a way to show the error as null instead of error?

The current formula is: if product contains bill then yes else null.

For items where the product field is null it is showing error. I want it to show as null

Thanks in advance

wrap the if step in try ... otherwise which is the M code version of Excel's IFERROR function

something like

try if Text.Contains([Product], "bill") then "yes" else null otherwise null

 

[gigi79]

wrap the if step in try ... otherwise which is the M code version of Excel's IFERROR function

something like

try if Text.Contains([Product], "bill") then "yes" else null otherwise null

Worked perfectly. Thank you!