Mastering Power Automate: The Power of the split() Function

Unlock Workflow Efficiency with Power Automate's split() Function

When constructing workflows in Microsoft Power Automate, you'll frequently encounter scenarios where multiple values are delivered as a single text string. To effectively process each of these values individually, the crucial step is to convert that string into an array. Fortunately, Power Automate provides a straightforward and highly efficient solution: the split() function.

This article will guide you through the practical application of the split() function, illustrating its utility with common use cases and clear examples.

Why Leverage the split() Function?

The split() function is an indispensable tool for several key reasons:

Convert Text to Arrays: Seamlessly transform delimited text into structured array data.
Individual Value Processing: Enable the independent handling and manipulation of each data element.
Dynamic Looping: Facilitate the use of values within Apply to Each loops for iterative processing.
Handle Varied Data: Effectively manage data separated by commas, semicolons, or any custom delimiter.
Simplify Data Transformation: Streamline complex data manipulation within your automated workflows.

Understanding the split() Function

The syntax for the split() function is elegantly simple:

split('','')

Parameters Explained:

string: This is the text content you intend to split.
delimiter: This is the specific character or sequence of characters used to separate the values within the string.

Example 1: Splitting a Comma-Separated String

Imagine you have the following string:

Apple,Banana,Orange

To convert this into an array, you would use the following expression:

split('Apple,Banana,Orange',',')

The resulting output will be an array:

[
  "Apple",
  "Banana",
  "Orange"
]

Example 2: Splitting a Semicolon-Separated String

For strings using a different separator, like semicolons:

Input: John;Peter;David

Expression: split('John;Peter;David',';')

Output: ["John", "Peter", "David"]

Example 3: Splitting Dynamic Content

When dealing with dynamic content, such as values received from a form submission, a SharePoint column, or a Dataverse field, the process is similar. For instance, if you receive a string of email addresses:

Email1@company.com,Email2@company.com,Email3@company.com

You would use an expression like this, referencing the dynamic content:

split(triggerBody()?['Emails'],',')

This expression dynamically creates an array from the 'Emails' field, which can then be readily processed within an Apply to Each action.

Utilizing split() with Apply to Each

Once you've successfully converted your string into an array using split(), the next logical step is often to process each item in that array individually. This is where the Apply to Each control becomes invaluable.

Add an Apply to Each action to your flow.
In the Select an output from previous steps field, choose the output of your split() expression.
Within the Apply to Each loop, you can now add actions to process each value independently.

For example, if you split the string '1001,1002,1003' using a comma delimiter:

split('1001,1002,1003',',')

The Apply to Each loop will iterate through the resulting array, processing each item (1001, 1002, 1003) one at a time.

Common Use Cases for split()

Processing Email Recipients: Convert a comma-separated string of email addresses (e.g., user1@company.com,user2@company.com,user3@company.com) into an array to dynamically populate recipients for sending emails.
Working with CSV Data: Split values from a CSV formatted string into separate records, making them easier to process within your Power Automate flows.
Handling Record IDs: Manage multiple Dataverse or SharePoint record IDs that are received in a single string format.
User Input Parsing: Break down user-entered values, which might be concatenated with a specific delimiter, into smaller, more manageable components for further processing.

Combining split() with Other Functions

The power of split() is amplified when combined with other useful Power Automate expression functions:

Get the First Value: Use the first() function to retrieve the initial element of the split array.
first(split('Apple,Banana,Orange',',')) results in Apple.
Get the Last Value: Employ the last() function to extract the final element.
last(split('Apple,Banana,Orange',',')) results in Orange.
Count Items in the Array: Utilize the length() function to determine the total number of items in the array.
length(split('Apple,Banana,Orange',',')) results in 3.

Best Practices for Using split()

To ensure robust and reliable workflows, keep these best practices in mind:

Validate Input: Always validate that the string you are attempting to split actually contains data before executing the split() function to prevent errors.
Consistent Delimiters: Ensure that the delimiter used throughout your data source is consistent. Inconsistent delimiters can lead to incorrect splits.
Handle Empty Values: Implement logic to manage potential empty values that might result from consecutive delimiters (e.g., value1,,value3) to avoid unexpected behavior.
Trim Whitespace: When values might contain leading or trailing spaces (e.g., Apple , Banana ), use the trim() function in conjunction with split() to clean up the data: trim(item()) within an Apply to Each loop.
Test Thoroughly: Before deploying your workflows, test your split() expressions rigorously with various sample data inputs to confirm they produce the expected results.

Real-World Scenario: Email Notifications from SharePoint

Consider a common scenario where a SharePoint list has a single text field designated to store multiple email addresses, separated by commas:

john@company.com,mary@company.com,david@company.com

Using the split() function, you can convert this comma-separated string into an array. Subsequently, you can employ an Apply to Each loop to iterate through this array and send individual notification emails to each recipient. This approach significantly enhances the flexibility of your workflows and makes them far easier to maintain and troubleshoot.

Conclusion

The split() function stands out as one of the most valuable expression functions available in Microsoft Power Automate. It empowers you to transform raw text strings into structured arrays, simplifying the process of handling multiple values, iterating through records, and ultimately building more dynamic and adaptable workflows.

By strategically combining split() with other Power Automate functions, you can achieve efficient data transformation and gain greater control over your automation solutions.