Information

IfError

Returns a fallback value, or runs an action, when a formula produces an error.

Syntax

IfError(Value1, Fallback1 [, Value2, Fallback2, ...] [, DefaultResult])

Examples

  1. IfError(Value(txtQty.Text), 0)

    0 when the text is not a number

  2. IfError(Patch(Tasks, ThisItem, { Status: "Done" }), Notify(FirstError.Message, NotificationType.Error))

    Shows the error if the save fails

Official documentation on Microsoft Learn

↑ ↓ moveEnter open