Skip to main content

How to Join Text in Power Apps with & and String Interpolation

· 4 min read
Jagdish Kumawat
Founder @ Dewiride

"Welcome, Olivia" is fixed text joined to a value from a formula. Power Apps gives you two ways to write that: the & operator, and string interpolation with $"...". They produce the same text; the difference is how readable your formula is. Here are both, tried side by side in Studio.

Prerequisites​

Option 1: The & Operator​

Put & between the pieces. Text in quotes, formulas as they are:

lblWelcomeHS → Text
"Welcome, " & MyProfile.givenName

The formula bar with "Welcome, " & MyProfile.givenName, the preview strip reading Welcome, Admin with Data type text

Mind the space: it's inside the quotes, after the comma. Without it you'd get "Welcome,Admin".

Option 2: String Interpolation​

Start the text with $, and put formulas inside curly braces:

lblWelcomeHS → Text
$"Welcome, {MyProfile.givenName}"

The formula bar with the interpolated string $"Welcome, …" that puts MyProfile.givenName in curly braces, the preview strip reading Welcome, Admin with Data type text

Same result. Microsoft's data types reference adds two details: spaces around the braces are kept exactly as typed, and to show a literal brace, double it: {{ or }}.

Which to Use?​

SituationEasier with
One value joined to some textEither
Several values in a sentenceString interpolation: $"{Name} has {Count} requests"
Building text step by step in long formulas&

Any formula can go inside the braces, as long as its result can be turned into text. The example's final welcome uses Coalesce to fall back to the full name when the first name is missing:

lblWelcomeHS → Text
"Welcome, " & Coalesce(MyProfile.givenName, MyProfile.displayName)

See How to Replace Blank Values in Power Apps with Coalesce.

Tip: Seeing the Whole Result in Studio​

The preview strip under the formula bar shows the value of the part of the formula your cursor is in. With the cursor at the end of "Welcome, " & Coalesce(...), it showed only the Coalesce result. Put the cursor on the & to see the whole sentence.

Common Mistakes​

MistakeWhat happensDo this instead
No space inside the quotes"Welcome,Admin""Welcome, "
Forgetting the $The braces show as literal text$"..."
Using Concat to join two piecesIt expects a tableUse & or $"..."; Concat is for tables

FAQ​

Is & the same as Concatenate?​

Yes, for individual pieces of text. "A" & "B" and Concatenate("A", "B") give the same result.

Can I put numbers in?​

Yes; they're converted to text. To control the format, use Text: see Convert Number or Integer to Text or String using Power Apps.

Can interpolated strings be nested?​

Yes. Microsoft's reference shows an interpolated string inside another one's braces.

Conclusion​

"text " & value and $"text {value}" both join text; choose whichever reads better. Watch the spaces, and remember the $.

Additional Resources​

Stay Updated

Subscribe to our newsletter for the latest tutorials, tech insights, and developer news.

By subscribing, you agree to our privacy policy. Unsubscribe at any time.