extracting html table from outlook using power query

osama_ayoub — Sun, 02 Jul 2023 08:13:45 GMT

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])
)
))

Re: extracting html table from outlook using power query

osama_ayoub — Tue, 04 Jul 2023 17:53:16 GMT

Could you help me please?
ppm1

@slorin

@BA-Pete

topic Re: extracting html table from outlook using power query in Power Query

extracting html table from outlook using power query

Re: extracting html table from outlook using power query