Concat & Split Functions in Power Apps – A Complete Guide

📌 Introduction

In Power Apps, working with text and collections efficiently is crucial for data manipulation and transformation. Two essential functions for handling string concatenation and splitting text values are:

• Concat() → Used to join (concatenate) text values from a table or collection into a single string.
• Split() → Used to divide (split) a text string into a table based on a specific delimiter.

Understanding how to use these functions correctly allows you to manage data dynamically and improve user experience in your Power Apps applications.

---

🔹 Step 1: Understanding the Concat() Function

✅ What is Concat()?

The Concat() function is used to combine text values from a collection or table into a single string. It is particularly useful when displaying multiple values as a single text output or when formatting data for external usage.

✅ Syntax of Concat()

Concat( Table, Column, Separator )

• Table → The collection or table containing data.
• Column → The column to extract and concatenate values from.
• Separator (Optional) → A string used to separate concatenated values (e.g., comma, space, new line).

---

🔹 Step 2: Using Concat() with Collections

✅ Example 1: Concatenating Names from a Collection

📌 Scenario: Suppose you have a collection of employees and want to display their names in a single string separated by commas.

🔹 Step 1: Create a Collection

ClearCollect(Employees, 
    {Name: "John"}, 
    {Name: "Alice"}, 
    {Name: "Mark"}
)

🔹 Step 2: Use Concat() to Combine Names

Concat(Employees, Name, ", ")

📌 Output: "John, Alice, Mark"

---

✅ Example 2: Concatenating Email Addresses for an Email Field

📌 Scenario: You want to send an email to multiple recipients using a list of emails stored in a collection.

🔹 Step 1: Create a Collection of Emails

ClearCollect(EmailList, 
    {Email: "john@example.com"}, 
    {Email: "alice@example.com"}, 
    {Email: "mark@example.com"}
)

🔹 Step 2: Use Concat() to Format Email List

Concat(EmailList, Email, "; ")

📌 Output: "john@example.com; alice@example.com; mark@example.com"

---

✅ Example 3: Concatenating Product Details in an Order Summary

📌 Scenario: You have an order summary containing product names and their prices. You want to generate a summary string.

🔹 Step 1: Create a Collection of Products

ClearCollect(Products, 
    {Product: "Laptop", Price: "$1000"}, 
    {Product: "Mouse", Price: "$50"}, 
    {Product: "Keyboard", Price: "$80"}
)

🔹 Step 2: Use Concat() to Format Product List

Concat(Products, Product & " - " & Price, "; ")

📌 Output: "Laptop - $1000; Mouse - $50; Keyboard - $80"

---

🔹 Step 3: Understanding the Split() Function

✅ What is Split()?

The Split() function divides a text string into separate values based on a specified delimiter. It is useful for extracting data from concatenated text and converting it into a table format.

✅ Syntax of Split()

Split( Text, Delimiter )

• Text → The text string to be split.
• Delimiter → The character(s) used to split the string (e.g., comma, space, newline).

---

🔹 Step 4: Using Split() to Extract Values

✅ Example 1: Splitting a Comma-Separated String into a Table

📌 Scenario: You have a string containing names separated by commas and need to extract each name into a separate row.

🔹 Step 1: Define a Text String

Set(NameString, "John, Alice, Mark")

🔹 Step 2: Use Split() to Convert to a Table

Split(NameString, ", ")

📌 Output Table:

Result
John
Alice
Mark

---

✅ Example 2: Extracting Words from a Sentence

📌 Scenario: You have a long sentence and want to extract individual words.

🔹 Step 1: Define a Sentence

Set(Sentence, "Power Apps is a great tool")

🔹 Step 2: Use Split() to Extract Words

Split(Sentence, " ")

📌 Output Table:

Result
Power
Apps
is
a
great
tool

---

✅ Example 3: Extracting Values from an Email List

📌 Scenario: You receive a list of email addresses separated by semicolons and want to split them into individual records.

🔹 Step 1: Define an Email String

Set(EmailString, "john@example.com; alice@example.com; mark@example.com")

🔹 Step 2: Use Split() to Convert to a Table

Split(EmailString, "; ")

📌 Output Table:

Result
john@example.com
alice@example.com
mark@example.com

---

🔹 Step 5: Combining Concat() and Split()

✅ Example: Converting a Collection to Text and Back to a Collection

📌 Scenario: You need to store a collection as a string, send it to an external system, and later convert it back to a collection.

🔹 Step 1: Convert Collection to Text Using Concat()

Set(ProductString, Concat(Products, Product, ", "))

📌 Output: "Laptop, Mouse, Keyboard"

🔹 Step 2: Convert Text Back to a Collection Using Split()

ClearCollect(NewProducts, Split(ProductString, ", "))

📌 Output Collection:

Result
Laptop
Mouse
Keyboard

---

🔹 Step 6: Best Practices for Using Concat() & Split()

✅ Use Concat() when you need to generate formatted text from collections.
✅ Always specify a delimiter in Concat() for better readability.
✅ Use Split() when extracting individual values from a string.
✅ Trim extra spaces when using Split() to ensure clean data.
✅ Combine Concat() and Split() to store and retrieve dynamic data.

---

🔹 Conclusion

The Concat() and Split() functions in Power Apps are essential for handling text data dynamically. While Concat() helps join multiple records into a single text string, Split() enables breaking a string into individual components. Mastering these functions allows you to manipulate and transform data efficiently in your Power Apps applications.

Now you can confidently use Concat() & Split() in your Power Apps projects!

---