Parsing emails is super boring so having a Flow that takes care of downloading attachments and sorting them is a huge timesaver. I have an article that discusses how to do that, and you find it here, but today let’s push ourselves a bit more. Since the body of the email is HTML (not always, but we’ll consider only HTML emails for this article), download a file from a link in an email, even if they are not attachments. Then, we’ll parse the body of the email, find links, try to follow them, and save any files that we get. Also, we’ll figure out the type of file and save it with the correct extension.
Thanks to @ lequocminh1 for getting in touch with this interesting challenge.
So let’s look at how to build a cool template to achieve this. If you don’t want to read further, here’s the solution template you can import with both Flows.
Since this template can be used in other places, we won’t bind it to an email. However, with the “Run Child Flow,” we can call this template everywhere we need it.
We have two inputs:
- The HTML string to parse
- The file path to save the file. We’ll use OneDrive for Business, but you can also use a SharePoint Site or Microsoft Teams to do this.
Now that we have what we need, we’ll do the following:
- First, split the HTML by “href”. This way, we’ll get an array with all the links.
- If we have more than 2 rows (at least one link), parse it.
- Finally, clean the link and download it.
That’s it. I’ll explain this action individually because it can cause some confusion.
The Split function is our best friend here to start breaking the data apart from for processing. We have a huge string of HTML code, and we need to find the href tags. If you’re not familiar with HTML, the links are always with the following syntax:
<a href="<URL>" ...>Text of the Link</a>
I’m oversimplifying here, but it’s not important to know in dept how links work.
Let’s imagine that we have the following HTML:
... <a href="https://manueltgomes.com"> ... <a href="http://twitter.com/manueltgomes"> ...
We want to break everything into an array and clean it to get only the links. If we split the array by
<a href with the following formula:
 - ...  - ="https://manueltgomes.com/">...  - ="http://twitter.com/manueltgomes">...
We can ignore the first row, and we have two more array items with the links we need. In future actions, we’ll clean the remaining HTML that is not necessary.
I’ll initialize a new array variable that will be used to deal with errors.
Since it’s important to do some error handling, we’ll collect all invalid downloads and errors during the Flow and return them at the end of the Flow. This way, we can collect them in the Flow that calls this one and deal with them if needed.
Parse the results
Now that we have the HTML split, we have two possibilities:
- First, we only have one row. Second, if this is the case, there are no links to parse.
- We have more than one row, so we have links to download.
Just because we find links doesn’t mean that there’s something to download on the other side. But we’ll only know when we actually download and see what we get.
Skip the row
To ignore the first row, we’ll use the skip function. Here’s the formula:
The function will return an array starting at the position that you provide it. In our case, we want to ignore the first element of the array, so we’ll start in position 2. Don’t forget that the positions start at “0,” so we want to move forward at the second position, hence the “1”.
The array is now this:
 - ="https://manueltgomes.com/">...  - ="http://twitter.com/manueltgomes">...
Now that we have only the links let’s parse them.
Parse the links
Let’s go to the meat of the template. Now we’ll use an ”Apply to Each” action that gets all the array elements that we filtered in the previous step and prepare them to download.
First, we remove the beginning of the tag. Here’s the formula:
We use 4 functions here:
- item function to get the current item in the ”Apply to Each” action
- indexOf function to find the first occurrence of the quote
- Add function to increase the position by one.
- Substring function to get the string that we need.
Let’s bring the array again:
 - ="https://manueltgomes.com">...  - ="http://twitter.com/manueltgomes">...
We want to fetch the first instance of the first quote and get the string after that since we don’t want to include the quote we need to add one to the position to ignore it.
So looking at the first, we get:
Now let’s remove the end of the link. To do that, we’ll use the same strategy but starting from zero until the next quote. Here’s the formula:
As you can see, we’ll use the output of the previous action. With this, we get:
Now we’re ready to do the download.
As I mentioned before, this is a premium action. I’ll try to find another solution for this but, in the meantime, that’s the one we have.
Parse the download
After the HTTP action, we have two outcomes. The first is we don’t manage to download anything. It can be for several reasons so that the HTTP action will return an error. We’ll deal with it by adding to the array an error message. This is represented above by the right branch
Looking at the left branch, we get something useful downloaded, so let’s save it. The HTTP returns a lot of stuff to us, and one that is super important is the
content-type type of information that we retrieved. There’s a lot, but we need this to save the file in the correct format. Since the
content-type is something like
image/png (for a PNG file), we need to translate this into
<Insert template link here>
To do it, we have another Flow that we call using the “Run Child Flow” action that we built with one thing in mind. It will get a
content-type and will return an extension.
Saving the file
Let’s save the file.
As you can see above, the OneDrive For Business “Create File” action has:
- The “Folder Path” that we got in the trigger
- The “File Name” is generated with a random number using the “rand” function and the extension from the previous step.
- The “File Content” is the result of the HTTP action.
There’s an interesting thing that we’re doing here, where we only add to the error array if there’s an error saving the file. This will enable us to have an exception to send to the user once the Flow finishes running.
Now that we have everything, let’s return something.
We have two possibilities. If we don’t have values in the array, we will need to send the reply to the user with the list of the errors. To do so, we’ll use the join function.
This will generate a string with all the error messages separated by commas. If we don’t have errors, we return the error message.
What about the email part?
We mentioned in the beginning that we want to download a file from a link in an email, but up until now, we don’t mention the email part. I did this on purpose because I wanted to show you that the main part is parsing the HTML. With this template, you can use it for emails or for any other HTML parsing needs that you may have. I’ve also included in the solution a template for the email, and it’s as simple as this:
There are a lot of advantages to doing it this way.
- We can have multiple triggers calling the same Flow. If you have multiple folders that you want to monitor, you only need to duplicate the 2 steps above, and you’re good to go.
- You can look at multiple services. So if you want to check your Gmail and Outlook, for example, you can. It’s all in the trigger.
- Any changes in the “Parse HTML and download all attachments” will be propagated to all Flows that call it.
Finally, let’s look at error handling. Since the “Parse HTML and download all attachments” returns an error, we can look at it and deal with the error.
There are many ways to deal with errors, so I’ll leave it up to you on how you want to do it.
Parsing HTML is hard, so it’s possible that the Flow won’t work for all cases. My objective is to show you how to download a file from a link in an email while making things generic enough that you can download a file from any HTML code.
If you find any issues, please email me a sample of your HTML, and I’ll try to make this template better for everyone.