How to Remove HTML and JSON Formatting When Saving Kaizala Data to SharePoint
Question details
The user needs to extract plain text from Kaizala responses by removing HTML markup and JSON structures before saving the data to SharePoint.

- Product
- Power Automate, SharePoint
- Device & OS
- not provided
- Scenario
- Transferring form responses or chat data from Kaizala to a SharePoint list using a Microsoft Power Automate flow.
- Observed behavior
- The transferred text is stored with HTML wrapper elements like 'ExternalClass' and contains JSON-style brackets instead of displaying the plain text response.
Ensure you have edit access to your Power Automate flow and basic familiarity with adding 'Data Operation' and 'Content Conversion' actions.
Use Power Automate Expressions and HTML to Text Actions
Modify your flow to explicitly parse the JSON response and convert any HTML-formatted rich text into plain text before updating the SharePoint item.
By default, Kaizala may send data in a rich text (HTML) or JSON array format. Power Automate will simply copy this raw structure into SharePoint unless you instruct the flow to extract and clean the text.
In your flow, add a 'Parse JSON' action immediately after the Kaizala trigger. Use the schema of the Kaizala output to isolate the specific string value you want to save, stripping away the outer JSON brackets.
Click 'New step' and search for 'Html to text' (under Content Conversion). Map the extracted dynamic content from your 'Parse JSON' step into this action. This natively strips out 'ExternalClass' wrappers and standard HTML tags.
In your 'Create item' or 'Update item' SharePoint action, map the target column to the output of the 'Html to text' action rather than the original Kaizala response.

Try WPS Office for Managing Exported SharePoint Data
While Power Automate manages your background data transfers, you can use WPS Office as a fast, lightweight alternative to Microsoft Office for viewing, analyzing, and reporting on the data you export from SharePoint.
- 1. Download the software: Visit the WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen prompts to set up the Writer, Spreadsheet, and Presentation tools.
- 3. Open exported SharePoint lists: Export your SharePoint list as an Excel or CSV file, and open it seamlessly in WPS Spreadsheet for advanced data analysis.

Frequently Asked Questions
Why does Kaizala data appear with HTML tags like 'ExternalClass' in SharePoint?
Kaizala often formats text responses as rich text. When Power Automate transfers this data directly, the underlying HTML structure (such as div tags with 'ExternalClass') is carried over to SharePoint unless explicitly converted to plain text within the flow.
Can I use a SharePoint calculated column to remove the HTML tags?
SharePoint calculated columns do not natively support robust string manipulation for stripping HTML tags. It is highly recommended to clean and parse the data within the Power Automate flow before the record is created in SharePoint.
What expression removes specific JSON characters like brackets in Power Automate?
You can use the replace() function in Power Automate to remove specific characters. For instance, the expression replace(variables('yourText'), '[', '') can be used to manually remove opening JSON brackets if standard parsing actions are not viable.




