Power Automate: Remove End of Line Characters

Problem

Parsing text can be somewhat tricky with Microsoft Power Automate or Azure Logic Apps. Recently I needed to strip out end-of-line characters (CR/LF) from a text string.

This task actually proved to be a bit more challenging than I had expected… However in this post I’ll share the solution that I found and ultimately ended up using.

Solution

The following expression will remove the end-of-line characters from text strings in your Power Automate or Azure Logic Apps workflow.

uriComponentToString(replace(uriComponent(<YOUR_TEXT_HERE>), '%0A', ''))

Example

To demonstrate this, we have a Power Automate workflow that does the following:

1. Extracts the plain text from a text string containing HTML content.
2. Writes the output to a text file.
3. Writes the output to another text file, however in this file, the end-of-line characters are removed by using the above expression.

Final Thoughts

I hope this solution has helped you. If you find an alternative solution, feel free to post it below to help others out there.

Happy Power-Automating!