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?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

JonDoesFlow 1,304 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Longely 36 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Longely 36 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Longely 36 on at

Like (0)

Report
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?

Was this reply helpful? Yes No
Longely 36 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

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

replace(outputs('Compose'), decodeUriComponent('%0A'), '')

Was this reply helpful? Yes No