HTML detection & html tag removal

Power Query
1

Hi all,

Anyone have code to detect “HTML” example in query editor if text.left = < & text.right = >, but more importantly, how to automatically strip all tags and/or convert to default text?

You may or may not know that PowerApps/Dynamics know supports HTML editing for multiline text fields, so this is going to be a very frequent question very soon.

PS: for those who think: I’ll just use the HTML visual, you should know you can’t export that to pdf or ppt so other than on the report itself, it has little value.

Regards,

Christopher

2

Hi @Wlknsn,

I remember seeing a post about that, can you see if this is helpful.

For a Custom Column:
Html.Table( [Your Column Name Here], {{"text",":root"}}){0}[text]

and a link to the documentation: https://docs.microsoft.com/en-us/powerquery-m/html-table

I hope this is helpful.

6 Likes
3

Hi @Wlknsn, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!

4

Hi @Wlknsn
In the meantime, the HTML Text Styler custom visual has been certified by Microsoft so you can now also use it to export to pdf and ppt in the Power BI Service.
Take a look at it here: https://kteam.ch/text-styler