Part 5.2 - Text Actions: Append Line to Text, Split Text, and Join Text

Before getting into this, I hope you had a chance to review the subtle yet important differences between a Text variable and a List variable. If not, feel free to check 5.1 out, here:

Here are the definitions from Microsoft's documentation located here: https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/text#text-actions:

• Append line to text: Appends a new line of text to a text value
• Join text: Converts a list into a text value by separating its items with a specified delimiter
• Split text: Creates a list containing the substrings of a text that are separated by a specified delimiter or a regular expression

Now, why did I choose to focus on these 3? They are all inherently related. The only difference between the 3 is what they start with and where they end up.

• Append line to text: Text1 + Text2 = Text1 (New Line) Text2
• Join text (by delimiter-comma): List (containing Text1 and Text2) = Text1,Text2
• Split text (opposite of join text): Text1,Text2 = List (containing Text1 and Text2)

Here is what it looks like in action:

I hope this gave you a better understanding between the 3. This should allow you to move easily back and forth between list and text variables as well as add to them if need be. Until next time!

Michael Annis has no affiliation with Microsoft or its subsidiaries.?The “Best Practices” are purely compilations of his opinion and observations of conversations on the Power Automate Desktop User Community; an individual’s use of them should be taken as such.?Michael Annis has been using Robotic Process Automation (RPA) for over 2 years and maintains a “Top Solution Author” position on the Microsoft Power Automate Desktop User Community standings.?The best place for users to get their questions answered is through the User Community located here:?https://powerusers.microsoft.com/t5/Power-Automate-Desktop/bd-p/MPADesktop .