@chrisisconfused You just need to use the split() function and split your subject line into two separate parts and split it again.
To help you better understand how the split() function works, refer to this section of my YT Tutorial:
7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️
In this section, I'll cover how to get dynamic content with an expression when the dynamic content you need isn't listed in the dynamic content menu.
In the full tutorial I cover 7 functions you need to know when getting started with expressions.
1️⃣ empty()
2️⃣ coalesce()
3️⃣ equals()
4️⃣ if()
5️⃣ concat()
6️⃣ length()
7️⃣ split()
I cover how to use these functions in expressions and I’ll also cover common mistakes when it comes to writing expressions and show you a few tips and tricks along the way.
As a beginner or even an intermediate flow builder—expressions can seem a bit complex at first, I’m going to try to simplify it for you. If you want to level up your flows by writing expressions—keep watching!
IN THIS VIDEO:
✅ What is an Expression?
✅ What is a Function?
✅ What Does Wrapping a Function Mean?
✅ How Do I Insert an Expression?
✅ How to Use a Compose action
✅ How to Navigate the Expression Builder with Arrow Keys
✅ How to use the Expression Tooltip
✅ Common Mistakes When Writing Expressions
✅ How to differentiate a null from an empty string
✅ How to Get Dynamic Content When it’s Not Listed
✅ How to Use a Get Item Action to Verify Dynamic Content Output
✅ How to Convert Strings to Lower Case
✅ How to Troubleshoot the if() Function
----
Start with a Manual Trigger and store your sample subject line into a Compose action. This will help you to better understand how the split() function works.
Split the Subject Line
Add another Compose action to store the flag type. Insert the split() function.
The split() function takes two parameters:
split([string],[separator])
For this first example, insert the output from the Compose action holding the subject line as the string, add a comma and between single quotes enter your separator. In this case, use ' red flag on '. Ensure you are including the space before the word red and a space after the word on.
Run a test. The split() function will output an array of items.
Get the Flag Type
To get items of an array you can use the first() function to return the first item of an array, or the last() function to return the last item of an array. You can also use an index number [0],[1],[2] etc to return a specific item in an array. The first item of an an array is [0], second is [1] etc
In this case, we want to return the first item of the array. Add a Compose action to store the Flag Type.
Add an expression and insert the first() function.
Click on the dynamic content tab and insert the output from the Compose action with the split subject array.
Run a test. Review the outputs. The Compose action should output the first item of the array.
As before use a split() function. Click on the expression to edit it. Type in split with an opening parenthesis.
Press the down arrow key to go to the end of the expression. Add a comma and single quotes. Between the single quotes enter the separator. In this case it's New with a space.
Important: Don't forget to press update.
Run a test. The split() function has converted the string to an array. Wrap your expression in the last() function to return the last item of the array.
Click on the expression to edit it. Type in last with an opening parenthesis.
Press the down arrow key to go to the end of the expression and enter a closing parenthesis.
Important: Don't forget to press update.
Run a test.
You can use another Compose action to store the unit name by using the last function on the Split Subject compose action. The Compose actions aren't necessary, however when you are working with expressions it can help you to better understand how to build an expression by using Compose actions and breaking it up into parts. It can make it easier to build the expression and edit it in the future.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution
✅.
Consider giving me a
👍 if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on
YouTube👉 Tips and Tricks on
TikTok and
Instagram
