Power Automate Concatenate Strings

Do you want to know how to use Concat in Power Automate? In this Power Automate tutorial, I will show you how to concatenate strings in Power Automate. We will see a few power Automate concat string examples.

  • Power Automate Concatenate Strings
  • Concatenate a variable with a string in Power Automate
  • How to concatenate a string with a string in Power Autoamte
  • Concatenate a string with a number in Power Automate
  • Power Automate concatenate a string with a date

Power Automate Concatenate Strings

In Power Automate we can concatenate strings by using the string concat() function.

There is a string function named Concat() that combines any number of strings together in Power Automate. The syntax for the concat function in Power Automate is:

Concat(text1,text2,....)

Now, let us see a few implementations of concat in Power Automate.

Example-1: Concat variable with string

Let’s look at the example below, where we will use this concat() function. For this, on Power Automate, first, we will trigger our flow manually by adding Trigger flow manually from the instant cloud flow.

Then, we will add an action to Initialize the variable. Here, we will give a name to our variable, set the type as a string, and value as triggered user name(it will show the user name who triggered the flow).

Power Automate concatenate string
Power Automate concatenate string

Then, we will add a Compose action where we will insert an expression that will be concatenating the user name with a string. The expression is:

concat('Have a Good day',' ',variables('VarString'))
concatenate string Power Automate
concatenate string Power Automate

Similarly, we can use any string value instead of the text i.e., have a good day. For space here, we use a ‘ ‘. Now, our flow is ready. So save and test the flow. The output will come like below:

power automate concatenate strings

This is how to concatenate the strings with variable on Power Automate.

See also  How To Get Row by ID From Dataverse Table

You can download this flow from here.

Example-2: Concat a string with another string (single line text)

In this example, we will see how to concatenate a string with another string in Power Automate. For example, we have a sharePoint list based on employee details having columns such as First name and last name (single-line text), Dept(choice field), joining date(date/time field).

But as per our requirement, when we insert the employee’s data on a SharePoint list, it will combine the first name and last name into full name and notify the Manager.

For this, we have discussed here the steps:

Step-1:

On Power Automate, we will add a trigger “When an item is created“. On that, we have to insert our SharePoint site address and the list name that we will use.

power automate concat string

Step-2:

Then we will add a Compose action, in that we will insert an expression that will perform the concatenation with two strings. The expression is:

concat(triggerOutputs()?['body/First_Name'],' ',triggerOutputs()?['body/Last_Name'])
concat in power automate
Concat two strings on Power Automate

Step-3:

Now we will add an action “Send an email“, which will notify the manager when a new employee details are created on the SharePoint list with the full name.

concatenate power automate

Now, our flow is ready to run. So save it and test it manually. When we enter first name and last name on the SharePoint list:

concatenate in power automate

But we can see it will contact the first name and last name on the mail:

power automate expression concatenate strings

This is how to concatenate two strings from the SharePoint list in Power Automate. You can download this flow from here.

See also  Create SharePoint Online List and Columns from Excel Using Power Automate [Download Complete Flow]

Example-3: Concatenate a string with a number

In this example, we will see how to concat a string with a number on Power Automate.

For this, we will add a trigger that will trigger the flow manually. On that trigger, we will use text input and number input.

concat power automate

Then, we will add a Compose action that will concate the text with a number by using an expression. Here is the Power Automate expression for concatenate strings.

concat(triggerBody()['text'],'-',triggerBody()['number'])
power automate concat

When we save & test the flow manually, it will ask us to enter the text and number and click on Run flow.

power automate concat strings

Now we can see the output is coming as a string with numbers by concatenating.

power automate string concatenation

This is how to concatenate a string with a number on Power Automate flow.

Example-4: Concate a string with date

Similarly, we will use a date as an input type on the manual trigger flow. Then, we will add a Compose action that will concatenate a string with a date by using an expression:

concat(triggerBody()['text'],'-',triggerBody()['date'])
power automate concat string with dynamic content
Concatenate a string with date on power Automate

Now, the flow is ready to run. Let’s insert a text and date value to check the output:

concat string power automate

Now we can see the output is coming by concatenating the string with date:

power automate combine strings
power automate combine strings

This is how to do Power Automate concat a string with a number.

Conclusion

In this tutorial, I hope you have learned how to use the concat in Power Automate. We have also seen a few examples related to Power Automate concatenate strings. If you still have any questions related to concatenate in Power Automate, add them in the comments below.

You may also like:

>