Others

Fix Power Apps HTML Text Display When Retrieving SharePoint Data

Muhammad TalhaMuhammad Talha Nov 2, 2026 868 views

Question details

The user needs to fix an issue where Power Apps displays raw HTML tags instead of formatted text when pulling data from a SharePoint list.

Fix Power Apps HTML Text When Retrieving SharePoint Data
Product
Power Apps, SharePoint
Device & OS
not provided
Scenario
Retrieving data into Power Apps from a SharePoint list that was originally imported from an Excel spreadsheet.
Observed behavior
Unexpected HTML tags, such as font formatting tags, are visible in the Power Apps control instead of the expected plain or cleanly formatted text.
Before you start

Verify the column settings in your SharePoint list to ensure the text fields are set up correctly, and check the original Excel file to confirm no hidden rich-text formatting was carried over during the import.

Solution 1Recommended

Use the HTML Text Control in Power Apps

If your SharePoint data intentionally contains HTML formatting, using an HTML text control instead of a standard text label will render the tags properly as visual formatting.

Power Apps standard text labels do not parse HTML tags. By switching to a dedicated HTML control, the app will interpret the font and style tags correctly instead of displaying them as raw code.

1
Open Power Apps Studio

Navigate to your canvas app in Power Apps Studio and locate the screen where the SharePoint data is being displayed.

2
Insert an HTML text control

Click on 'Insert' in the top ribbon menu, search for 'HTML text', and add the control to your app canvas.

3
Set the HtmlText property

Select the newly added control and change its 'HtmlText' property in the formula bar to reference your SharePoint column (for example, type ThisItem.YourColumnName).

Use the HTML Text Control in Power Apps
Formatting Applied: The raw HTML tags will now disappear and the text will display with the intended fonts, colors, and styling.
Free Microsoft Office alternative

Manage Your Spreadsheet Data Cleanly with WPS Office

Prevent messy data imports into SharePoint and Power Apps by organizing your source spreadsheets with WPS Office. As a free, lightweight, and highly compatible alternative to Microsoft Office, WPS Spreadsheet ensures your data is clean and ready for seamless integration without hidden formatting conflicts.

  1. 1. Open your data in WPS Spreadsheet: Launch WPS Office and open the Excel file you intend to import into SharePoint.
  2. 2. Clear hidden formatting: Select your data columns, right-click, and use the 'Clear Formats' option to strip any hidden rich text or HTML styling.
  3. 3. Save as a clean file: Save the spreadsheet securely as a clean .xlsx or .csv file to ensure only raw text is pushed into your SharePoint list.
Ensure clean, plain-text data management to prevent unexpected HTML tag errors during SharePoint imports.100% compatible with Microsoft Excel formats (.xlsx, .csv) for seamless migration and data sharing.Lightweight and fast, allowing you to edit large datasets without performance lag or system crashes.Familiar, intuitive user interface that requires no learning curve for standard Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why do HTML tags appear when I import Excel data into SharePoint?

When Excel data containing hidden rich text formatting is imported into a SharePoint 'Multiple lines of text' column with 'Enhanced rich text' enabled, the underlying HTML formatting tags can be exposed when the data is subsequently pulled into external applications like Power Apps.

Will reimporting the Excel file fix the Power Apps HTML display issue?

Reimporting the Excel file rarely resolves this issue. The problem usually stems from how Power Apps interprets the rich text data type from SharePoint, rather than a corrupted file import. Formula adjustments in Power Apps are typically required.

How do I change my SharePoint column to prevent HTML tags in Power Apps?

In your SharePoint list settings, navigate to the affected 'Multiple lines of text' column and change the text type from 'Enhanced rich text (Rich text with pictures, tables, and hyperlinks)' to 'Plain text'. Be aware that this action will remove any existing formatting in that column.

What information should I provide when asking for help in the Power Apps Community?

To receive the most accurate help, provide the data types of your SharePoint columns, a few rows of sample data showing the HTML tags, the exact Power Apps formula you are using, and the type of control (e.g., Label or HTML text) displaying the data.