Whys isnt split working ?

(0) Share

Report

Posted on by smallzoo

after html to text I get ...

Membership Number: 123456789

Application Reference: hshshshshshshshsh

EMPLOYER

Name: Fred Bloggs LIMITED

if I add a compose with an expression split(body('Html_to_text'),'\n\n')

the output is the same ?

Raw input
"Membership Number: 123456789\n\nApplication Reference: hshshshshshshshsh\n\n\nEMPLOYER\n\nName: Fred Bloggs LIMITED\n\n"

Raw Ouput
"Membership Number: 123456789\n\nApplication Reference: hshshshshshshshsh\n\n\nEMPLOYER\n\nName: Fred Bloggs LIMITED\n\n"

What am I doing wrong ?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @smallzoo ,

This is because '\n' isn't html in body('Html_to_text'), it has been converted to text.

If you want to identify '\n' in body('Html_to_text'), please try this.

Then modify your expression.

split(body('Html_to_text'),outputs('Compose'))

Best regards,

Rimmon

Was this reply helpful? Yes No
smallzoo 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks but I dont understand

this is the simple flow
The RAW output of the HTM to Text is

"body": "Membership Number: 123456789\n\nApplication Reference: hshshshshshshshsh\n\n\nEMPLOYER\n\nName: Fred Bloggs LIMITED\n\n"

The Compose expression is

split(body('Html_to_text'),outputs('Compose'))

The RAW outputs of the Compose is

"Membership Number: 123456789\n\nApplication Reference: hshshshshshshshsh\n\n\nEMPLOYER\n\nName: Fred Bloggs LIMITED\n\n"

I'm missing something !

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @smallzoo ,

Thanks for your positive response.

I retest your problem and here is a method may help solve your problem.

replace(outputs('Html_to_text')?['body'],'\n',decodeUriComponent('%0A'))

Best regards,

Rimmon

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Your "Raw Ouput" is the Power Automate object converted to a JSON string.

In a JSON you must not confuse /n with ordinary characters.
In JSON, the backslash is a control character which in this case means that the following n is a newline character.
If this JSON is turned into a Power Automate object, /n is just one character meaning "new line".

Within a Power Automate expression you can write this new line character as decodeUriComponent('%0A')

Was this reply helpful? Yes No