Answered

How to concatenate on to a single line in Power Automate Desktop

(1) Share

Report

Posted on by IAQG

Hi all,

I think I'm missing something simple, but I was wondering what the best way to concatenate two strings in to single line string is in Power Automate Desktop? I see that there's a step to append two strings together, but that adds the second string in to a new line instead of a single one. So as an example, if I wanted to concat "dollar" and "bill" to "dollar bill", using the append function I get
"dollar

bill"

The way I found around this is to split the new variable in to a list delimited by new line and then join the list delimited by a space, but that seems like a roundabout way to what I would think is a simple concat.
Thanks!

Categories:

Process mining

I have the same question (0)

All responses (7)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi! Are dollar and bill stored in separate text variables? I’m new to PAD, but I was playing around. I have 2 text variables—%NewVar% and %NewVar2%—where the first stores dollar and the second stores bill. I used a Display Message action to concatenate them with a space by typing %NewVar% %NewVar2% just as shown, and it displayed dollar bill. Will that work?

Was this reply helpful? Yes No
Verified answer

CFernandes 8,482 Most Valuable Professional on at

Like (5)

Report
Copy link

Link copied!

Hey Mate @IAQG ,

You can use + operator to concat -

Have a look at - https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation#basic-arithmetic

Note in set variable % symbols are the start and end- %VarDollar + VarThis%

Option 2 - As suggested by @Anonymous

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
burque505 398 on at

Like (2)

Report
Copy link

Link copied!

And if you want to do it by setting variables, you can try this:
Setting var 1 (has a space you can't see at the end):
Setting var 2:
Setting var 3 to concatenate vars 1 and 2:
And the result ( you can see the double percent signs from var 2 have been converted to single percent signs):

Was this reply helpful? Yes No
IAQG 96 on at

Like (1)

Report
Copy link

Link copied!

Ah, there it is. Thanks, all, I knew there had to be something easier than what I was doing.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@IAQG I am glad our inputs helped!!

Was this reply helpful? Yes No
minhhoangn 40 on at

Like (1)

Report
Copy link

Link copied!

Now 06/02/2024 (dd/mm/yyyy) Version Power automate desktop 2.40.00207.24023
Anotation % not working. syntax when use variable: =variable name . I can not concat string in power automate desktop right now.
color is a variable, not use with old syntax. New syntax: =color . It's working but can not concat string or multi variable.
Can you help me fix it?
Thanks in advance.

Was this reply helpful? Yes No
NRoger 2 on at

Like (0)

Report
Copy link

Link copied!

You must have enabled "Use Power FX" when you created your flow. That's why it's not working for you.

Was this reply helpful? Yes No