The Split function in PowerApps is used to divide a text string into a table of substrings based on a specified delimiter. This function is particularly useful when you need to parse and manipulate text data that is formatted in a specific way, such as CSV data, space-separated words, or other delimited text.
PowerApps – Split() function Syntax
- Text: The text string that you want to split.
- Separator: The delimiter used to split the text string into substrings.
Notes:
- Empty Strings: If the text string is empty, Split returns an empty table.
- Missing Separator: If the separator is not found in the text string, the entire string is returned as a single value in the table.
PowerApps – Split() function basic example
Suppose you have a text string "Red,Green,Blue" and you want to split it into individual colors:
Split("Red,Green,Blue", ",")
This returns a table with the values Red, Green, and Blue.
PowerApps – Split string by space
If you have a sentence and you want to split it into individual words:
Split("PowerApps is amazing", " ")
This returns a table with the values PowerApps, is, and amazing.
PowerApps - Split a CSV Line
Suppose you have a CSV line and you want to split it into individual fields:
Split("John,Doe,30,Developer", ",")
This returns a table with the values John, Doe, 30, and Developer.
If you have a URL with query parameters and you want to extract specific values:
// Assuming URL is "http://example.com?page=1&sort=asc"
Set(QueryString, "page=1&sort=asc");
Set(QueryParameters, Split(QueryString, "&"));
This splits the query string into individual parameters: page=1 and sort=asc.
PowerApps - Parse Multi-Select Values
If you have a multi-select control that returns a concatenated string of selected values and you want to split it into individual items:
Split(SelectedValues, ";")
This splits the selected values based on the semicolon delimiter.
PowerApps – Split() function example in an App
Suppose you have a text input control where users can enter comma-separated values, and you want to display these values in a gallery:
- Add a Text Input Control
Name the text input control TextInput1.
- Add a Button to Trigger the Split
Add a button control and set its OnSelect property to:
Set(SplitValues, Split(TextInput1.Text, ","))
- Add a Gallery to Display the Split Values
Add a gallery control and set its Items property to:
Set the Text property of a label inside the gallery to:
This will display each value from the comma-separated input in the gallery as individual items.