I'm trying to replace newline \n with an * using the following compose @replace(body('Html_to_text'),'\n','*'). Nothing happens, I have tried several variation of this function /\n /\n/ "/n" ..
Solved! Go to Solution.
Mike, thanks but the "Char()" function is not supported. Although I figured it out, you have to LITERALLY put the new-line in the FLOW in single quotes. This works:
@replace(body('Html_to_text'),'
','*')
Hi @Paul1,
Could you please share your flow configuration in a screenshot?
The replace function would work for string, and if you would like to replace the CRLF code into "*", I think that may not be available through the replace function.
You may take a try with the code below:
@replace(body('Html_to_text'),char(13),'*')
Char(13) here means the newline (CR).
See if it would work in this way.
Regards,
Michael
Mike, thanks but the "Char()" function is not supported. Although I figured it out, you have to LITERALLY put the new-line in the FLOW in single quotes. This works:
@replace(body('Html_to_text'),'
','*')
Thanks Paul, it was driving me mad trying to find a way of doing this and your post pointed me in the right direction.
I couldn't get it to work exactly as you did but instead I intitialised a variable - which I called "crlf" - at the top of the Flow. I set that to a literal carriage return as you did (by pressing the Enter key) and then used the variable in the "replace" function as follows: (I had a "Data Operations - Compose action called "Message" which contained some Sharepoint list multiline plain text columns which I wanted to format properly within a HTML email, so needed to replace line endings with the <br /> tag).
Hi @Anonymous,
I'm facing the same issue, try to replace the new lines with a " * ".
Can you provide a screenShot please of the flow, soory i didn't get the solution that you mentioned.
Thank you.
Hi Marwa1,
The screenshot below is an example of replacing newlines with asterisks as you were trying to do.
In the "Initialize variable" step Value looks empty but in fact it contains a newline character (entered by pressing the Enter key).
In the "Compose 2" step the expression in full is
Running the flow gives the following output:
Hi @Anonymous, Sorry the second set of screenshots above is jumbled - hope they make sense.
CollinB, your solution is much more elegant, then mine..!
worked perfectly!!!
This worked perfectly for me, thanks!
For those who are looking what that 'Compose' action is in the spanish version look no more, it's 'Redactar' under 'Operación de datos'.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
6 | |
5 | |
4 | |
1 | |
1 |