cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FelipePanza
Helper II
Helper II

Populate a MS Word template from Sharepoint List Multiline

Hi, is there a way to keep the line break from Sharepoint list when convert to a Word file?

 

I have managed to make a Word table from Sharepoint with repeting table.

 

Skjermbilde 2021-05-08 kl. 18.45.10.png

 

The Output: The Column number 3 should have line breaks like is in my Sharepoint list.

Skjermbilde 2021-05-08 kl. 18.48.37.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
FelipePanza
Helper II
Helper II

I found a solution.

When you are creating a template with content control make sure you edit the properties to:

select Allow carriage returns (multiple paragraphs).

 

This allowed me to keep the line break from sharepoint list with plain text.

View solution in original post

4 REPLIES 4
rrovira
Microsoft
Microsoft

Hello, @FelipePanza!

 

Yes, there are some workaround to get this done. However, the action "Populate a Microsoft Word Template" doesn't do that on its own. I did however found a similar post that might help you with this: https://powerusers.microsoft.com/t5/Using-Flows/SharePoint-Multiple-lines-of-text-column-and-Send-an...

 

Let me know if it helped you keep the break lines in your cell! 

 

Cheers,

Rodrigo

FelipePanza
Helper II
Helper II

Where in my flow should I do this?

 

Compose the multiple lines to URI encoding, a then replace the line break %0A with the desired formatting, such as </br>.

FelipePanza
Helper II
Helper II

Hi can I add a replace expression inside the Select action?Skjermbilde 2021-05-09 kl. 21.14.39.png

FelipePanza
Helper II
Helper II

I found a solution.

When you are creating a template with content control make sure you edit the properties to:

select Allow carriage returns (multiple paragraphs).

 

This allowed me to keep the line break from sharepoint list with plain text.

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,695)