HTML Table for Report that will run biweekly

[DCNehs]

I have a scheduled workflow that will run every 2 weeks to send a DL a list of items to verify they have fixed.  I'm using "Get Items".  Everything is working fine, except that the "Verification" multiline column is sending the information all in a single line of information instead of having the return breaks.  Have tried several different variables, splits, etc that I've found online but still no luck.

I changed the column from Rich Text to Plain Text on the SharePoint List and in the PowerApp have it set to Edit multi-line of text.  Made sure to refresh the data.  I've also tried removing the data card and re-adding but same outcome.

Here is a snapshot of the table.  The verification area is still showing in a single line, but on the form, there are returns.  If I'm sending a normal email with updates everything works ok, it's just this Get Items scheduled report where i'm seeing this happen.

Any ideas?

[v-duann-msft · Accepted solution]

Hi @DCNehs 

Thank you for posting.

According to your description, you would like to achieve line break in a HTML table but flow always returns single line which is out of your expectation.

Yes, you are right. Even though we set up multiline type column in SharePoint list, it will be changed to single line after ‘create html table’.

So we need to add extra steps to insert lines.

Here is my list:

Flow overview:

Expression: replace(body('Create_HTML_table'),outputs('Compose'),'<br>')

In the first compose, we should click on ‘Enter’ key to input a empty line here.

After testing, I’m able to get line break.

Hope the content above may help you.

Best regards,

Anna

[DCNehs]

PERFECT!!!!  Thank you so much.  I was looking at something I got awhile ago from someone that was like this but i couldn't figure out what I was missing. I'm definitely noting it this time.