How to stop power automate from lumping everything into one big paragraph

[ianallen13]

Hello, 

I have a workflow that grabs info from SharePoint and then emails it out (nothing too fancy), however, the customer has noticed and asked that it does not send it out the way that it is formatted in SharePoint.  It just lumps it all together into one paragraph in the email.  

Here is a copy of the email output workflow - like I said - nothing too fancy, but the 'topics covered' just gets lumped into one large paragraph instead of broken up.  I want it so that my front users can post what they need in the format that they want, and get the email in basically the same format.  

[ManishSolanki]

Hi @ianallen13 

You can use 'Code View' option in send and email action to do some html formatting:

You may use <p>, <br>, <table> tags etc. as per your need.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[ianallen13]

Hello, 

Thank you for the response - but I need something automated, not something that I would have to adjust each time.  Any other thoughts?

[TheRobRush]

you need to split your topics covered into an array of some sort, and then use append to variable to loop through them all and append something like <li> the result </li> to the string over and over, then in final email, use html like the previous poster suggested and put <ul> reference to your variable </ul>

[TheRobRush]

As an example

this string in second initialize is a bunch of line separated by line breaks

so i initialize an array variable and give it the value of

split(variables('Test'),decodeUriComponent('%0A'))

and then do an apply to each to on test2 and in it append to string variable

<li>items('Apply_to_each')</li>

like so

i then switch my email to html mode and

<ul>variables('htmlItems')</ul>

like so

which results in this email

[ianallen13]

Thank you!  I'll try this tomorrow and see if I can get it to work.  Much appreciated. 

[ianallen13]

Sorry for the delay on responding, 

I'm not sure that this will quite work for what I need.  The field that I have being filled out called 'Topics Covered' is in SharePoint a multi-line free form field where someone is just writing out the weekly topics.  No bullet points really.  Is there a way to save the format of how they write it and get it to spit that same output in the same fashion?

Basically, the user writes three paragraphs - the email shows three paragraphs.  Not one paragraph with all the items jammed together?