Have you ever written a Power Apps formula that looked like a jumbled mess of ampersands (&) and quotation marks? Something like "Hello " & TextInput1.Text & ", your order total is $" & Text(varTotal, "0.00") & " and will be delivered on " & Text(varDate, "mm/dd/yyyy")?
Yeah, I’ve been there too. It works, but it’s hard to read and even harder to debug when something goes wrong.
String interpolation is the elegant solution to this problem. It lets you embed variables and expressions directly inside text without all those concatenation operators. The result? Cleaner formulas that are easier to write, read, and maintain.
In this tutorial, I’ll walk you through everything you need to know about string interpolation in Power Apps, with plenty of practical examples you can use right away.
What Exactly Is String Interpolation in Power Apps?
String interpolation is a fancy term for a simple concept: putting variable values directly inside text strings.
Instead of breaking your text into pieces and gluing them together with the & operator, you write the entire text as one piece and insert placeholders where you want dynamic values to appear.
In Power Apps, you use dollar sign notation with curly braces: $"Your text {YourVariable} more text"
The dollar sign before the opening quote tells Power Apps “hey, this string contains expressions you need to evaluate.” Anything inside the curly braces gets calculated and inserted into the final text.
Why Should You Use Power Apps String Interpolation?
Before we dive into the how-to, let me give you three solid reasons why this matters:
It makes your formulas cleaner. Compare these two approaches:
Old way:
"Welcome " & User().FullName & "! You have " & CountRows(MyCollection) & " items."
New way: $"Welcome {User().FullName}! You have {CountRows(MyCollection)} items."The second one is just easier on the eyes.
It reduces errors. When you’re juggling multiple ampersands and quote marks, it’s easy to miss one or put it in the wrong spot. String interpolation cuts down on those syntax mistakes.
It saves time during debugging. When you come back to your app three months later (or when someone else opens it), clean formulas are much faster to understand and modify.
Basic String Interpolation Syntax
Let’s start with the fundamentals. The basic pattern looks like this:
$"Static text {DynamicExpression} more static text"Here’s a simple example:
$"Hello {TextInput1.Text}!"
This takes whatever the user typed in TextInput1 and inserts it into your greeting.
A few key rules to remember:
- Always start with the dollar sign ($) immediately before the opening quotation mark
- No space between $ and the opening quote
- Put expressions inside curly braces { }
- Everything outside the braces is treated as literal text
Check out Get Collection Column Names in Power Apps
Power Apps String Interpolation with Variables
Variables are probably where you’ll use string interpolation most often.
Let’s say you’re building an order confirmation screen in a Power Apps canvas app. You’ve set these variables:
Set(varCustomerName, "Sarah Johnson");
Set(varOrderNumber, 12345);
Set(varOrderTotal, 156.75);
Here’s how you’d create a confirmation message:
$"Thank you, {varCustomerName}! Your order #{varOrderNumber} for ${varOrderTotal} has been confirmed."Result: “Thank you, Sarah Johnson! Your order #12345 for $156.75 has been confirmed.”