cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DCNehs
Post Patron
Post Patron

HTML Table for Report that will run biweekly

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?

 

multilineText.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
v-duann-msft
Community Support
Community Support

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:

v-duann-msft_0-1620119811668.png

 

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.

v-duann-msft_1-1620119811674.png

 

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

v-duann-msft_2-1620119811677.png

 

v-duann-msft_3-1620119811679.png

 

Hope the content above may help you.

 

Best regards,

Anna

View solution in original post

2 REPLIES 2
v-duann-msft
Community Support
Community Support

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:

v-duann-msft_0-1620119811668.png

 

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.

v-duann-msft_1-1620119811674.png

 

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

v-duann-msft_2-1620119811677.png

 

v-duann-msft_3-1620119811679.png

 

Hope the content above may help you.

 

Best regards,

Anna

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. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,515)