Extracting Html Table from Outlook Email

[hellodazza]

Hi there, 

I would like to extract a html table from outlook email. The table in the emails are always in a standard format. I can see the text format and also the html format of this email. I just want to keep and compile this table in Power Bi as and when we get these kind of emails. I am able to see these emails in Power Bi. I can see the html body and also the text body. Just don't know how to maintain the table and compile them. 

Any help appreciated. Thanks.

Clip ID	Titles/Matches	Event Dates	Start Time	End Time	Dur(hr)	SVOD output time	OTT output time	Remarks
CR000001367	UAE's International League T20 2023 Gulf Giants v Desert Vipers	04-Feb-2023	2200	0220	4.5	0023	2244	Via Volicon
SE000001347	Serie A 22-23 Cremonese vs Lecce	04-Feb-2023	2155	2355	2	0113	0009	Via Volicon
CR000001547	UAE's International League T20 Highlights 2023 Match 27	05-Feb-2023	2200	2230	0.5	2343	2323	Via Volicon
CR000001368	UAE's International League T20 2023 Abu Dhabi Knight Rider v Sharjah Warriors	04-Feb-2023	2200	0220	4.5	0343	0214	Via Volicon
FR000000678	Ligue 1 22-23 PSG v Toulouse	04-Feb-2023	2355	0155	2	0313	0201	Via Volicon
FR000000679	Ligue 1 22-23 Troyes v Lyon	05-Feb-2023	0155	0355	2	0513	0407	Via Volicon
CR000001548	UAE's International League T20 Highlights 2023 Match 28	05-Feb-2023	0230	0300	0.5	0323	0305	Via Volicon
FR000000680	Ligue 1 22-23 Rennes v Lille	05-Feb-2023	0355	0555	2	0643	0555	Via Volicon

[hellodazza]

Hi @lbendlin , 

I want to extract the data and compile them to be later used with any visualization. Thanks.

Cheers
Darren

[lbendlin]

Do you want to extract the data, or do you want to display the email in Power BI?  For the second option you can use one of the HTML viewer visuals.