Answered

New line for each Sharepoint list value in a "multiple lines of text" column

(1) Share

Report

Posted on by vipfafen

Hi all,

I built a flow that reads a Sharepoint list and sends the information via email. The problem in this case is a column of type "multiple lines of text". I can't get a line break for multiple entries.

Flow is processed successfully, but without line breaks. The values are written one after the other.

My Flow:

Affected value: "Aktive Zugriffspakete"

expressions i tryed:

- concat(item()?['AktiveZugriffspakete'],decodeUriComponent('%0A'))

- item()?['AktiveZugriffspakete'],decodeUriComponent('%0A')

Sharepoint List:

- ist well formated

Mail Output:

- there are no line brakes

I would be very grateful for suggestions

Regards

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @vipfafen

Pls try replacing line feed '\n' with <br> html tag using the below expression:

replace(item()?['AktiveZugriffspakete'],decodeUriComponent('%0A'),'<br>')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
vipfafen 98 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManishSolanki,

thank you for you replay. The Mailoutput looks like that:

it's not what i'm expected, but close

Regards

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @vipfafen

Please revert the changes in "Select" action i.e.

item()?['AktiveZugriffspakete']

In the email where you show the table using its output, use the below expression:

replace(body('Create_HTML_table'),decodeUriComponent('%0A'),'<br>')

Here is an example:

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
vipfafen 98 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi and thank you @ManishSolanki,

now i have my new lines for each eantry, thank you! But my "Compose -add CSS" is gone.

How to bring back my CSS?

Regards and Thank you one more time @ManishSolanki

Was this reply helpful? Yes No
vipfafen 98 on at

Like
a
(0)

Report
Copy link

Link copied!
ok, it's fixed. In my case placed this...
replace(body('Create_HTML_table'),decodeUriComponent('%0A'),'<br>')
...directly in "Compose -add CSS".
Thank you @ManishSolanki, Problem is solved. Is less of a problem and more of a gap in my knowledge...

Was this reply helpful? Yes No