How to Preserve HTML Code as Plain Text in Power Automate and SharePoint
Question details
The user needs to display raw HTML tags as literal text in SharePoint when sending data from a multiline field via Power Automate.

- Product
- Power Automate and SharePoint
- Device & OS
- not provided
- Scenario
- Transferring a multiline field containing HTML code from Power Automate to a SharePoint list or document library.
- Observed behavior
- SharePoint renders the HTML tags (such as <h2> and <p>) as formatted text instead of displaying the raw HTML code.
Ensure you have Edit or Full Control permissions for the target SharePoint list, and verify you can access and modify the associated Power Automate flow.
Configure SharePoint Column Settings to Plain Text
Change the multiline text column configuration in SharePoint to plain text so it stops interpreting and rendering HTML tags.
By default, SharePoint multiline text columns may be set to Enhanced Rich Text, which automatically renders standard HTML tags into formatted text. By enforcing plain text, you ensure that any HTML code sent from Power Automate is treated as literal characters.
Navigate to your SharePoint list or document library. Click the gear icon in the top right corner and select 'List settings' or 'Library settings'.
Scroll down to the 'Columns' section and click on the name of the multiline text column that is currently receiving the HTML data.
Under the 'Additional Column Settings' section, find the option specifying the type of text to allow. Select 'Plain text' instead of 'Enhanced rich text (Rich text with pictures, tables, and hyperlinks)'.
Click 'OK' at the bottom of the page to save your changes. Run a test through your Power Automate flow to verify that the HTML tags now appear as visible code.

Encode HTML using Power Automate Expressions
Use expressions in Power Automate to replace HTML brackets with their corresponding entity codes before sending the data to SharePoint.
Looking for a Lightweight Document Solution? Try WPS Office
While complex SharePoint and Power Automate workflows require specialized Microsoft environments, everyday document processing doesn't have to be complicated. WPS Office provides a highly compatible, free, and lightweight suite for creating, editing, and managing your files with ease.
- 1. Download WPS Office: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install the Application: Run the installer and follow the on-screen instructions to set up WPS Office in minutes.
- 3. Open Your Office Files: Launch WPS Office and directly open any existing .docx, .xlsx, or .pptx files to experience seamless compatibility.

Frequently Asked Questions
Why does SharePoint automatically format my HTML code instead of showing the tags?
By default, multiline text columns in SharePoint are often configured to 'Enhanced rich text'. This setting commands SharePoint to interpret standard HTML tags (like <h2> or <p>) as formatting instructions rather than literal text.
Can I use Power Automate to convert HTML to plain text without showing the tags?
Yes. If your goal is to strip the HTML tags entirely rather than preserve them as visible code, you can use the 'Html to text' action built into Power Automate before sending the string to SharePoint.
Will changing a SharePoint column to Plain Text affect existing list items?
Yes. When you change an existing 'Rich text' or 'Enhanced rich text' column to 'Plain text', SharePoint will warn you that all existing formatting in that column will be permanently lost for older entries.




