Extracting HTML Code from Power Bi

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi LoMorrissey 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If your issue resolved, kindly mark the helpful response and accept it as the solution to assist other community members in resolving similar issues more efficiently. If not, please provide detailed information so we can better assist you.

you can define the following function and use it in your code

(inputText as text) as table =>
    if Text.StartsWith(inputText, "<") then
        Table.Combine({
            Html.Table("<div>" & inputText & "</div>", {{"Final Decision Notes", "div"}}),
            Html.Table("<div>" & inputText & "</div>", {{"Final Decision Notes", "br"}})
        })
    else
        #table({"Final Decision Notes"}, {{ inputText }})

Hi LoMorrissey 

You're trying to create a custom column in Power Query that extracts meaningful text from rows containing HTML content, while preserving rows that already contain plain text. Your current code attempts to parse HTML when the Final Decision Notes column starts with a < character (which typically indicates HTML), and otherwise returns the original value. However, you're using Table.Combine(...) inside a row-level expression, which is designed to return a table, not a value, and that causes inconsistency—Power Query expects each row to return a scalar (like a single text value), not an entire table.

What you're missing is the extraction of text from the HTML table structure into a single value per row. Also, you need to ensure the output is consistently a single text string, regardless of whether the input is HTML or plain text.

Here’s a corrected version of your logic:

= if Text.StartsWith([Final Decision Notes], "<") then
    let
        html = "<div>" & [Final Decision Notes] & "</div>",
        divTable = Html.Table(html, {{"Text", "div"}}),
        brTable = Html.Table(html, {{"Text", "br"}}),
        allText = List.Combine({divTable[Text], brTable[Text]}),
        mergedText = Text.Combine(List.Select(allText, each _ <> null), " ")
    in
        mergedText
else
    [Final Decision Notes]