Power Fx function
IsBlankOrError — Power Fx function reference
Test for blank or error.
Syntax
powerfx
IsBlankOrError( Value )
Examples
powerfx
IsBlankOrError(LookUp(Staff, ID = locId))
→ true / false
powerfx
If(IsBlankOrError(LookUp(Staff, ID = locId)), Navigate(scrNotFound), Navigate(scrDetail))
powerfx
IsBlankOrError(1/Value(txtDivisor.Text))
Common mistakes & gotchas
- Useful because a failed LookUp returns blank while a bad conversion or division by zero returns an error — this single check covers both without two separate tests.
- It swallows the error silently with no detail available — use IfError instead when you need to inspect or log what went wrong.
Related Power Fx functions
From Conditional logic