A Power Apps label that reads “Hello, !” looks broken. So does a gallery row with an empty space where an asset tag should be. Blank values are normal in real data, but your users shouldn’t have to see them.
The Power Apps Coalesce function fixes that in one line. You hand it a list of values, and it returns the first one that isn’t blank or an empty string. Everything after that gets skipped.
In this tutorial, I’ll show you how to use the power apps coalesce function with six tested examples: fallback text, a chain of values, blank SharePoint columns, LookUp misses, default values in a new record and the empty string trick.
Power Apps Coalesce Function Syntax
The Coalesce function in Power Apps takes one or more values:
Coalesce( Value1 [, Value2, ... ] )
| Parameter | Required | Type | Description |
|---|---|---|---|
Value1 | Yes | Any (text, number, date, record…) | The first value to test. |
Value2, ... | No | Same type as Value1 | More values, tested in order until one isn’t blank and isn’t an empty string. Values after that aren’t evaluated. |
Return value: the first argument that isn’t blank or “”. If every argument is blank or an empty string, Coalesce returns blank. All arguments must share one type, and the result has that type.
Coalesce uses the same test as the IsBlank function, so Coalesce(a, b) is the short version of If(Not IsBlank(a), a, b), without calculating a twice.
Delegation: Power Apps can’t delegate Coalesce. Used on a column inside Filter, it limits the query to the first 500 rows. Used on a control value, it’s a constant and the query still delegates. My Power Apps delegation tutorial covers the limit.
Here’s the warning Studio shows on the column version. It counted 166 High requests, while the list really has 206:

Pro Tip: Coalesce works in any property of a canvas app, not only behavior formulas. It’s a plain value, so use it in Text, Default, Items or inside Patch.
When to Use the Coalesce Function in Power Apps
- Show a friendly fallback (“guest”, “Not scheduled”) instead of an empty label.
- Pick the first filled-in value from several inputs or columns, like mobile phone, then work phone.
- Give a new record default values when a user leaves fields empty, before Patch or Collect.
- Handle a modern drop-down that starts blank, as in setting a dropdown default value to blank.
- Turn an empty string into a real blank before you save it to SharePoint.
Example 1: Show a Fallback When a Text Input Is Empty
On a welcome card, a modern text input asks for a name, and a label greets the user. When the box is empty, I want “guest” instead of nothing.
First, where to type the formula. Select the label in the Power Apps Studio tree view, pick Text in the property dropdown to the left of fx, and type in the formula bar. Press Play (top right) to test, or hold Alt and click into the text input.

"Hello, " & Coalesce(txtCoName.Text, "guest") & "!"
How does this work?
txtCoName.Text is an empty string when the box is empty, so Coalesce skips it and returns “guest”. The label shows “Hello, guest!”. After I typed Jordan, it showed “Hello, Jordan!”.

Example 2: Return the First Non-Blank of Several Values
A contact card has two phone boxes. Maria Torres left her mobile empty but entered a work number:
| Input | Value |
|---|---|
| Mobile | (empty) |
| Work | (312) 555-0148 |
The label’s Text property gets this formula:
"Call: " & Coalesce(txtCoMobile.Text, txtCoWork.Text, "No phone on file")

How does this work?
Coalesce checks the arguments left to right. Mobile is empty, so it moves on; work has a value, so it stops there and “No phone on file” is never evaluated. Result: “Call: (312) 555-0148”. With both boxes cleared, the label showed “Call: No phone on file”.
Example 3: Replace Blank SharePoint Values in a Power Apps Gallery
The IT Help Requests SharePoint list has two optional text columns, AssetTag and SiteUrl. I added four test requests (titles start with “Demo Coalesce”), and not every one has a value:
| Request | AssetTag | SiteUrl |
|---|---|---|
| Docking station | SPG-LT-2047 | (blank) |
| Finance site access | (blank) | /sites/Finance |
| Outlook keeps crashing | (blank) | (blank) |
| Monitor flickering | SPG-MN-1182 | /sites/ITHelp |
The gallery’s Items is Filter('IT Help Requests', StartsWith(Title, "Demo Coalesce")), and the row label’s Text is:
ThisItem.Title & " | " & Coalesce(ThisItem.AssetTag, ThisItem.SiteUrl, "No asset tag or site")

In Preview, every row shows something useful:

How does this work?
For each row, Coalesce tries the asset tag, then the site URL, then the note. Outlook keeps crashing has neither, so it shows “No asset tag or site”. Monitor flickering has both, and the asset tag wins because it comes first.
Example 4: Show a Message When LookUp Finds Nothing
In Power Apps, LookUp returns blank when no record matches. Here a user types a request ID, and the label shows that request’s title, the same idea as this lookup on a SharePoint list tutorial:
Coalesce(
LookUp('Service Requests', ID = Value(txtCoId.Text)).Title,
"No request with ID " & txtCoId.Text
)

How does this work?
With ID 12, LookUp finds the record and Coalesce returns its title, “Dock not charging #1011”. With ID 9999, LookUp returns blank, so the label reads “No request with ID 9999”.
Example 5: Fill Default Values in a New Record
Kevin Brooks adds requests from a small form: a subject box, a priority drop-down and an Add request button. Empty fields should get defaults. The button’s OnSelect adds a record to a Power Apps collection:
Collect(
colCoTickets,
{
Title: Coalesce(txtCoSubject.Text, "Untitled request"),
Priority: Coalesce(ddCoPri.Selected.Value, "Normal")
}
)

A small gallery on the collection shows each new row:

How does this work?
Each field gets its own Coalesce. I clicked the button with nothing filled in, and the new row read “Untitled request | Normal”. The same record works inside the Patch function when you save to SharePoint.
Example 6: Turn an Empty String Into a True Blank
Some controls return “” instead of blank. Coalesce with a single argument converts “” to blank. I tested three formulas side by side:
"" = Blank()
Coalesce("") = Blank()
IsBlank("")

How does this work?
The first comparison returned false, the Coalesce version true, and IsBlank true. An empty text input behaved the same way. IsBlank treats both as empty, as my IsBlank vs IsEmpty comparison shows. Wrap a text input in Coalesce before you save it, so SharePoint stores an empty value.
Coming from Power Automate? Its coalesce() expression returns the first non-null value, and an empty string counts as a value there. Power Apps’ Coalesce skips both blanks and empty strings.
Coalesce vs If(IsBlank()) in Power Apps
| Coalesce | If + IsBlank | |
|---|---|---|
| Returns | The first non-blank value | Whatever each branch returns |
| Repeats the value | No | Yes, once in the test and once in the result |
| Best for | Fallbacks and defaults | Different logic per case |
If you only need a fallback, use Coalesce. For anything else, see these Power Apps If statement examples.
Common Mistakes with the Power Apps Coalesce Function
- Mixing types.
Coalesce(Value(txtCoId.Text), "none")showed no error in Power Apps Studio. With an empty box, it failed at run time: “The value ‘none’ cannot be converted to a number.” Wrap the number in Text(). - Spaces aren’t empty. A box with one space gave “Hello, !”. Use
Coalesce(Trim(txtCoName.Text), "guest"). - Zero isn’t blank.
Coalesce(0, 5)returned 0, andCoalesce(false, true)returned false. - Coalesce on a column inside Filter.
Filter('Service Requests', Coalesce(Priority.Value, "Normal") = "High")shows the delegation warning. Use the constant pattern instead:Filter('Service Requests', Status.Value = Coalesce(ddCoStatus.Selected.Value, "New")). - No final fallback. If every argument can be blank, so can the result. End with a constant.
Wrapping Up
The Power Apps Coalesce function returns the first value that isn’t blank or an empty string, and skips the rest. Use it for fallback text, default values and LookUp misses in any canvas app.
For more formulas, browse all Power Apps functions. For the official definition, see the Coalesce function on Microsoft Learn.
Other Power Apps functions you may find useful:

Hi! I’m Preeti Sahu, a Microsoft MVP for Power Apps. I build business apps and automations with Power Apps and Power Automate on top of SharePoint Online, and I’ve worked with SharePoint and the Power Platform for more than six years. I’m also the co-author of the book Microsoft Power Platform: A Deep Dive. My tutorials come from solutions I’ve built, from galleries and forms to approval flows, and I test every step in a real Microsoft 365 tenant. Bijay Kumar reviews each tutorial before it’s published.