Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Extracting Html Table from Outlook Email

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



2 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi lbendlin , 

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

    Cheers
    Darren