Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I am trying to extract html table from outlook emails but I got only the text as a separated words not as a format of table ,
I expanded the column containg record of table (HtmlBody,HtmlText) before applying custom function ?
I used below function and got the error of can not convert to binary.
is this anyway to get the table from email as a table also ?
= Table.AddColumn(#"Expanded Body", "Custom", each Table.FromColumns(
List.Transform(
Html.Table(Web.Page(Text.FromBinary([HtmlBody]))),
each ([Column1])
)
))