How to save MS Forms data to SQL without the CSS/HTML tags

[Neil6]

Hi Everyone,

We created a survey using MS Forms, and what it does is it collects data, then collects them thru Power Automate then saves the collected information to an SQL database.

But the problem is that it also includes the CSS/HTML tags when saving to SQL. Below is a screen shot from the SQL database

Can anyone help me on how to clean my form entries before it saves to SQL?

Thank you in advance!! Stay safe!!

[Neil6 · Accepted solution]

Solved it!

I used HTML to text action and it worked like a charm