Rich text SPO column to rich textbox in word not translating

I have a multiline rich text SharePoint list column but when it is processed into a word document it shows as plain text with the html tags. I tried using the rich text box in the word template but it doesn’t work.

JSON data element is:

"Highlight": "<p><strong>Edited by NewsCenter</strong> Admiral&#160;<a target=\"_blank\" rel=\"noreferrer\" href=\"https&#58;//\">John Richardson</a>, the U.S. chief of naval operations, confirmed to Pentagon correspondent Carla Babb last week that the U.S. Navy is closely watching Iranian naval exercises in the Persian Gulf. The admiral, who is outranked only by the chairman and vice-chairman of the Joint Chiefs of Staff, made the remark as Reuters and CNN were basing reports about the exercises on unidentified sources. In the same face-to-face interview, Richardson talked broadly about U.S. naval strategy vis-à-vis Iran,&#160;<a target=\"_blank\" rel=\"noreferrer\" href=\"https&#58;//\">Chinese activity in the South China Sea</a>, and a&#160;<a target=\"_blank\" rel=\"noreferrer\" href=\"https&#58;//\">Russian submarine threat in the Atlantic</a>, generating a total of three stories. The Russian story, published Tuesday morning, was the top item in the Pentagon’s “Early Bird” daily news summary.&#160;&#160;&#160;</p>"

And this is how it shows in the word output.

Any ideas?

Hello @aortiz-arroyo,

Unfortunately, you can’t use Rich text column’s text in Create DOCX from Template action.

If you need to create a document based on a rich text column you might want to try Convert HTML to PDF action.

Thanks, @Oleg_Tsurkan. Do you know if Plumsail has plans to include similar functionality in the create docx from template action? This will be helpful especially since it’s a column type supported by SharePoint.

1 Like

Hello @aortiz-arroyo,

I’m afraid there are no plans for that. The thing is that the data you get from SP Get item action, for example, already contains HTML tags and Create DOCX from Template can only recognize strings or integers as an input data.

I’d like to register as a feature request:

a; stripping the HTML and rendering plain text
b; some “conversion” function which places into a DOCX with formatting intact.


1 Like

Hi @Ken,

Thank you for your request. Regarding the first option that you suggested. There is an action in Microsoft Flow called “HTML to text”, It is a part of “Content conversion” connector. Review this article for more information. You can use it to translate HTML to plain text before passing it to our actions.

Please let me know how it works for you.

1 Like

translating the HTML to plain text defeats the purpose of SharePoint supporting Rich Text. Microsoft PowerApps also recently started supporting Rich Textbox controls. This means more and more we will have the need to have rich text on documents, especially on Word.

Other document generation tools support this feature, however, they are not as easy to use as Plumsail, so I strongly encourage Plumsail to consider supporting this.

1 Like

Thanks Anton.

This works. I appreciate that you took the time to educate me about a non-plumsail part of Flow!

Anton’s solution works for me, for now, but it would be excellent to retain the HTML and render it into Word as html/rtf (whatever Word uses under the hood).

1 Like

I agree. @antonkhrit can we submit this as a new request?

This is rather disappointing. Are there still no plans to support rich text?

I have an issue where a user pastes data (with rich text) into a plain text field and Plumsail forms save and displays the info correctly

Then when I they Plumsails document to create the word document the data to the field is garbage

Does the action to create PDF files handle rich text fields correctly?

@Petr Is there any news on this? Would be very nice if some basic formatting is supported (e.g. bullet list and bold text)


Hello @phil,

Please describe your case with more details. What action do you use and what is the source data?

Best regards,
Petr Bushuev
Plumsail team

Hello @Petr

We use the DOCX converter and like to insert a rich text column. For us it would be nice if there is a way to show the text in the DOCX file with basic formatting from the rich text, so that selected HTML-tags (e.g. b-Tag to bold or ul-Tag to bullet list) will be converted and inserted as formatted text in the DOCX file. Do you see any possiblity to do this?

Today we remove all HTML tags from the rich text before converting to DOCX file.

Thanks and best regards