Fix Power Apps HTML Text Display When Retrieving SharePoint Data
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.

- 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.
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.
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.
Navigate to your canvas app in Power Apps Studio and locate the screen where the SharePoint data is being displayed.
Click on 'Insert' in the top ribbon menu, search for 'HTML text', and add the control to your app canvas.
Select the newly added control and change its 'HtmlText' property in the formula bar to reference your SharePoint column (for example, type ThisItem.YourColumnName).

Strip HTML Tags Using the PlainText Function
If you want to remove the HTML tags completely and display only clean plain text, you can wrap your data source in the PlainText function.
Seek Specialized Help from the Power Apps Community
Since reimporting the Excel file often does not resolve complex data-connection formatting issues, posting in the official community is the best path for specialized scenarios.
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. Open your data in WPS Spreadsheet: Launch WPS Office and open the Excel file you intend to import into SharePoint.
- 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. 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.

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.




