User Profile
LoMorrissey
Regular Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Extracting HTML Code from Power Bi
Hi, I asked one of my colleagues and he was able to give me this code which solved the issue: #"Added Custom" = Table.AddColumn( #"Replaced Value24" , "Custom", each if [Review Team Notes] = null or not Text.Contains([Review Team Notes], "<") then "<p>" & [Review Team Notes] & "</p>" else [Review Team Notes]), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each if [Custom] <> null then Html.Table([Custom], {{"text", ":root"}}) else [Custom]), #"Expanded Custom.1" = Table.ExpandTableColumn(#"Added Custom1", "Custom.1", {"text"}, {"Custom.1.text"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom.1",{"Review Team Notes", "Custom"}), #"Renamed Columns12" = Table.RenameColumns(#"Removed Columns",{{"Custom.1.text", "Review Team Notes"}}), #"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns12",{{"Review Team Notes", type text}}) in #"Changed Type2"2.2KViews0likes1CommentExtracting HTML Code from Power Bi
I am attempting to extract HTML text by creating a custom column but keep the rows with regular text at the same time. I have used this code to remove the HTML text but am missing the part where it keeps the rows with regular text: = if Text.StartsWith([Final Decision Notes], "<") then Table.Combine({ Html.Table("<div>" & [Final Decision Notes] & "</div>", {{"Final Decision Notes", "div"}}), Html.Table("<div>" & [Final Decision Notes] & "</div>", {{"Final Decision Notes", "br"}}) }) else #table({"Final Decision Notes"}, {{ [Final Decision Notes] }}) What am I missing?Solved2.5KViews2likes7Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.