SharePoint Document Issues

How to Preserve HTML Code as Plain Text in Power Automate and SharePoint

Jason MillerJason Miller Nov 4, 2026 870 views

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.

How to Preserve HTML Code as Plain Text in Power Automate and SharePoint
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.
Before you start

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.

Solution 1Recommended

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.

1
Open List Settings

Navigate to your SharePoint list or document library. Click the gear icon in the top right corner and select 'List settings' or 'Library settings'.

2
Select the Multiline Column

Scroll down to the 'Columns' section and click on the name of the multiline text column that is currently receiving the HTML data.

3
Change to Plain Text

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)'.

4
Save and Test

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.

Configure SharePoint Column Settings to Plain Text
Consider Data Loss: Warning: Switching a SharePoint column from Rich Text to Plain Text will remove existing rich text formatting from all previously saved entries in that column.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website to download the free installation package for your operating system.
  2. 2. Install the Application: Run the installer and follow the on-screen instructions to set up WPS Office in minutes.
  3. 3. Open Your Office Files: Launch WPS Office and directly open any existing .docx, .xlsx, or .pptx files to experience seamless compatibility.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Clean and familiar user interface ensuring seamless migration and zero learning curve.Lightweight installation that runs smoothly on Windows, Mac, Linux, and mobile devices.Built-in PDF editing tools for comprehensive document management without extra software.
microsoft office alternative - wps office

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.