Power automate concatenate different columns

Question

I need to concatenate three columns, two of which are calculated when calculated. I cannot join them in a list validation way. I would need to know how to do it in power apps.

Thanks.

Answer 1

Your question is not quite clear as question title is saying you need solution using "Power Automate", but in question body you asked how to do it using "Power Apps".

Anyway, I will try to answer your question using both the ways.

Using Power Apps:

In Power Apps, you can use Concatenate function to concatenate multiple strings/columns.

Example: To show three column values in single label control, you can use formula like below in "Text" property of label control to (Assuming ThisItem is complete list item/record having all column values):

Concatenate(ThisItem.FirstName, " " , ThisItem.LastName, " is from Country: ", ThisItem.Country)

OR:

ThisItem.FirstName & " " & ThisItem.LastName & " is from Country: " & ThisItem.Country

Documentation: Concat and Concatenate functions in Power Apps

---

Using Power Automate:

In Power automate, you can use concat() function in expression to concatenate multiple column values like:

concat('<text1>', '<text2>', '<text2>')

Documentation: concat() function