web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Body of email to excel...

Power Automate

Answered

Body of email to excel split at line breaks

(0) Share

Report

Report

Posted on by Bart_Smith

2

I've only just started with power automate, so may be missing something really obvious.

I've got a flow working - and email with a specific string in a subject line arrives, it adds a new row to an Excel table and populates the first column with the body of the email.

I want to split the email body into different columns each time there is a line break

I've tried this: split(outputs,char(10)) - but that doesn't work.
What am I doing wrong please?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
Couple of things wrong:

First of all, you have not specified an output in outputs. So it needs to be something like outputs('emailBody').

Secondly, there is no char function. But you can use the expression

decodeUriComponent('%0A')

instead. So your whole expression would be something like:

split(outputs('emailBody'), decodeUriComponent('%0A'))

Was this reply helpful? Yes No
Bart_Smith 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I'll give that a go.

Was this reply helpful? Yes No

Join the conversation