Split

How to Use the Power Fx SplitĀ  Function in Power Apps

In this article, we will show you how to use the Power Fx Split function in Power Apps. We will discuss the syntax of the function, explain how to use it with examples, and provide some tips for working with it.

Syntax of the Power Fx Split Function

The syntax of the Split function is as follows:


Split(Text, Separator)


Here, `Text` is the string that you want to split, and `Separator` is the character that you want to use as a separator. The function returns an array of substrings.

Using the Power Fx Split Function in Power Apps

Let's take a look at some examples of how to use the Split function in Power Apps.

Example 1: Splitting a Comma-Separated String

Suppose you have a text input control in your app that allows the user to enter a comma-separated list of items. You want to split this list into an array of items so that you can work with each item individually.

Here's how you can do it:

1. Create a variable to store the string input:


Set(varInput, TextInput1.Text)


2. Split the string into an array using the Split function:


Set(varArray, Split(varInput, “,”))


3. Now you can work with each item in the array using a ForAll loop:


ForAll(varArray,

// Do something with each item in the array

)


Example 2: Splitting a URL

Suppose you have a URL that you need to split into its component parts (protocol, domain, path, query parameters, etc.).

Here's how you can do it:

1. Create a variable to store the URL:


Set(varURL, “https://www.example.com/path/to/page.html?param1=value1&param2=value2”)


2. Split the URL into an array using the Split function:


Set(varArray, Split(varURL, “/”))


3. Now you can access the individual parts of the URL using array indexing:


Set(varProtocol, varArray[0]) // “https:”

Set(varDomain, varArray[2]) // “www.example.com”

Set(varPath, varArray[3] & “/” & varArray[4]) // “path/to/page.html”

Set(varQuery, varArray[5]) // “param1=value1&param2=value2”


Tips for Using the Power Fx Split Function

Here are some tips for working with the Power Fx Split function:

- The separator is case-sensitive. If you split a string using a lowercase separator, it will only split on lowercase instances of the separator.

- If the separator is not found in the string, the function returns the entire string as a single item in the array.

- If you need to split a string based on multiple separators, you can use the Substitute function to replace all the separators with a single separator before using the Split function.

- If you need to split a string into an array of integers, you can use the ForAll function to convert each substring to an integer.

In conclusion, the Power Fx Split function is a powerful tool for working with text data in Power Apps. By understanding its syntax and knowing how to use it with examples, you can easily split strings into arrays and work with the individual substrings. With the tips we provided, you can become even more proficient with this function and take your app development to the next level.

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