Adding a line feed or carriage return to data using REPLACE

[EdHansberry]

Hi, I have a Power BI report that is feeding data to Power Automate via the Power Automate button. I had formatted my data in Power BI with a UNICODE(10) character which is a line feed so the data would look like this:

PO#, Line#, Date, Amount
PO#, Line#, Date, Amount

but Power Automate stripped it out, so I get this:
PO#, Line#, Date, AmountPO#, Line#, Date, Amount

I can replace the UNICODE with this though:
PO#, Line#, Date, AmountXXXPO#, Line#, Date, Amount

So now I can use the Replace function (I hope?) in PA to reformat it replacing "XXX" with something to introduce a line feed. But I don't know what to use. I'm not seeing anything too useful on searching for that. Ideas? Or a different way to approach it?

[Pstork1]

The key to working with carriage returns using a replace() is to create a variable and initialize it by adding a blank line (ie, hitting your return key once in the field).  YOu can then use the variable as the replacement string for the "XXX" in your data.

[EdHansberry]

Sorry. I have no clear idea what you just said. I am a Power Automate novice.

I am able to get this to work:

23503500-7 August 08, 2021 Quantity Remaining: 3,504XXX23503500-8 August 08, 2021 Quantity Remaining: 5,502XXX23503500-9 August 08, 2021 Quantity Remaining: 3,000

becomes

23503500-7 August 08, 2021 Quantity Remaining: 3,504YYY23503500-8 August 08, 2021 Quantity Remaining: 5,502YYY23503500-9 August 08, 2021 Quantity Remaining: 3,000

That is major progress for me.

My Replace function is this:

replace(variables('MessageBody'), 'XXX', 'YYY')

What do I put instead of 'YYY' to get a line feed?

[EdHansberry]

Trying to work through what you said, I created a varable, string, and just pressed enter. Called it LineFeed. I then changed replace to this:

replace(variables('MessageBody'), 'XXX',variables('LineFeed'))

Didn't work. Now the XXX is gone, but everything is still on one line.

[Pstork1 · Accepted solution]

Like this

replace(variables('varTarget'), 'XXX', variables('varCRLF'))

Results in this:

[EdHansberry · Accepted solution]

Ok. that didn't work - the mail stripped it out again.

But.... it led me down the right path. I noticed in the raw inputs for the message it had <p> and </p> around it. So I figured basic HTML. So I replaced XXX with </BR> and that did the trick. Thanks for the pointers.

I marked mine and yours as the solution. Yours had the meat of the issue and was helpful. Mine had that last tweak necessary to get it to work with the Office 365 email connector.