Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
osama_ayoub
Helper III
Helper III

extracting html table from outlook using power query

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

 

osama_ayoub_1-1688285530170.png

 

1 REPLY 1
osama_ayoub
Helper III
Helper III

Could you help me please?
@ppm1 

@slorin

@BA-Pete

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors