How to edit raw data instead of formatted one

(0) Share

Report

Posted on by Longely

hello there,

I have set up a flow to turn

123-bla-user@mail.
domain. com

into "123-bla-user@mail.domain.com" but it just ends up with

123-bla-user@mail.\ndomain.com

instead. Although my flows starts with a html to text function, so I assume I need to change that to sth else but what?

All responses (8)

Answers (0)

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to edit raw data instead of formatted one

The following should work. Note that decodeUriComponent('%0A') represents a new line character.

replace(outputs('Compose'), decodeUriComponent('%0A'), '')
Longely 36 on at

Like (0)

Report

Re: How to edit raw data instead of formatted one

here is a shorted version of my flow with the problem reproducable. the replace function in compose 2 does nothing with the raw data and thus does not alter anything.
Longely 36 on at

Like (0)

Report
Re: How to edit raw data instead of formatted one

Sorry but that's way too much to show @Jondoesflow . Each flow steps has too much input and output to show all of the code, also if I am honest I don't get what new stuff it could show you.
Starting point is an email body containing "123-bla-user@mail.\ndomain. com" if looking at raw data or "123-bla-user@mail.
domain. com" if looking normal outputs/inputs field. After filtering the rest of the email body out I am left with that part, deleted the space after domain. com and now am stuck with
123-bla-user@mail.\ndomain.com
I don't think it makes any difference where in the flow the problem with \n is adressed or does it?
JonDoesFlow 1,304 on at

Like (0)

Report

Re: How to edit raw data instead of formatted one

No worries. Just difficult to reproduce on my end. Can you show a screenshot of a run of the flow with each of the steps expanded ?
Longely 36 on at

Like (1)

Report

Re: How to edit raw data instead of formatted one

thanks for your help @Jondoesflow
the weirdly formatted email is extracted from the body of an email.
the \n is included in the raw text output starting from the very beginning of the process.
JonDoesFlow 1,304 on at

Like (0)

Report

Re: How to edit raw data instead of formatted one

Hey @Longely I am missing the steps where the \n is getting added to the string. Can you show your flow in it's entirety ?
Longely 36 on at

Like (0)

Report

Re: How to edit raw data instead of formatted one

@Jondoesflow
already in place. As I said the shown and interacted with data looks like
123-bla-user@mail.
domain. com
so there is no "\n" to be removed. I need to force power automate to instead work with the raw data which would show
123-bla-user@mail.\ndomain.com
but how do i force that if not with html to text function?
JonDoesFlow 1,304 on at

Like (0)

Report

Re: How to edit raw data instead of formatted one

Hey @Longely

could you use the replace function ?

have a compose step after the email address with \n has been created

then do replace(‘your_action’?[‘your_field’],’\n’,’’)

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow