Unanswered

I can't figure out how create a flow to extract data from my Outlook email to create an excel table

(0) Share

Report

Posted on by Community Power Pla...

I'm trying to extract data from my Outlook email which is in HTML format with images. The output needs to be a clean excel table which can later be updated everyday.

I have two main questions:

1. Is there a better/faster way to do this? Would VBA be a better tool for this?

2. Where i'm struggling is to account for the fact that the number of rows or columns could change ie. the shape of the table within these emails could change. How can this be fixed?

Here is the flow I have so far. Since I'm not good with manipulating HTML code I tried converting HTML to text. In the 'EmailStep1' step I'm trying to slice the table portion of the email, but I can't figure out how to convert this to a table.

Flow Flow

I would truly appreciate any help here. Thank you very much in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

1) Yes. https://mailparser.io/
2) If the columns change that is tricky. Rows less so.
I'm sure what you want to do is possibly with a fancy enough set of expressions, but it's not an easy thing to do.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for your response Paulie. I would like to try myself first to hopefully save on the costs.

Fair enough; the columns should be the same actually. Would you be able to recommend the right step action I should be using? Any other tips you can offer would be highly appreciated. Thank you!

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

You'd need to post the HTML source of one of the emails for anyone to be able to give you any constructive advice on how to progress further. You could post it here in a code block, if it isn't huge, or put it in pastebin

Was this reply helpful? Yes No