jcalan8907 / 03_sharepoint-richtext-formating

Demo and M code function for stripping out the HTML tags from Rich Text fields when directly connecting to SharePoint List/Library

03_SharePoint-RichText-Formating

Demo and M code function for dealing with Rich Text results from a direct SharePoint connection with PowerQuery and PowerBI

Have you ever had to connect to a SharePoint list or library which has a Rich Text comment field?

Then I am sure you have noticed how the direct PQ/PBI Queries maintain the HTML tags in the results:

and I also assume you have exported that same list/library to Excel and noticed that the same rich text fields are much easier to read:

If you are like me there must be times when you would LOVE to strip out the HTML tags from the direct Query results and display the text in a simpler way (Similar to how an excel export does) for use in some of your PowerQuery/PowerBI reports.

Well great news!

this is exactly what we accomplish with a "simple" custom M function included in the sample files.
Feel free to check out my YouTube Video for tips.