Power Fx function
Coalesce — Power Fx function reference
First non-blank value.
Syntax
powerfx
Coalesce( Value1, Value2 [, Value3, ... ] )
Examples
powerfx
Coalesce(txtNick.Text, txtName.Text, "Guest")
→ First with content
powerfx
Coalesce(cmbAssignee.Selected.DisplayName, "Unassigned")
powerfx
Coalesce(txtNickname.Text, txtName.Text, "Guest")
Common mistakes & gotchas
- Coalesce treats an empty string ("") as blank for the purposes of skipping to the next argument, unlike IsBlank — a deliberate exception worth remembering.
- All arguments must be a compatible type; mixing a text default in with numeric earlier arguments forces an implicit coercion you may not want.
Related Power Fx functions
From Conditional logic