Concatenate

How to Use the Power Fx Concatenate  Function in Power Apps

What is the Concatenate Function?

The Concatenate function is used to combine two or more strings of text into a single string. It is a powerful function that is used in many programming languages. The Concatenate function is used to create dynamic text strings that can be used in various parts of a Power App.

Syntax of Concatenate Function

The Concatenate function has a simple syntax. You need to provide the strings of text that you want to combine as arguments to the function. The syntax of the Concatenate function is as follows:


In this syntax, Text1, Text2, … are the strings that you want to concatenate.

How to Use Concatenate Function in Power Apps

Using the Concatenate function in Power Apps is very simple. You just need to follow the below steps:

1. Open the Power App that you want to edit.

2. Select the control where you want to use the Concatenate function.

3. Click on the formula bar and type the Concatenate function as shown below:


4. Replace Text1, Text2, ... with the strings that you want to concatenate.

5. Press Enter to apply the function to the control.

Example of Concatenate Function in Power Apps

Suppose you have a Power App that has a text input control and a button control. You want to concatenate the text in the text input control with a static text string and display it in a label control when the button is clicked. The steps to do this are as follows:

1. Select the button control and click on the OnSelect property.

2. Type the following formula in the formula bar:


3. Press Enter to apply the formula.

Now, when you click on the button control, the concatenated text will be displayed in the label control. For example, if the text in the text input control is “John”, the label control will display “John is the input value”.

In conclusion, the Concatenate function is a powerful function that is used to combine two or more strings of text into a single string in Power Apps. It is very easy to use and can be used to create dynamic text strings in various parts of a Power App. With the help of the Concatenate function, you can improve the user experience of your Power App and make it more interactive and engaging for your users.

Power Apps Training Courses by G Com Solutions (0800 998 9248)