Parsing data from an HTML email for use in Sharepoint

[xbommer07]

I have an HTML email that when received I want to create an item in sharepoint and parse out values from the email to place in specific columns. 

I have everything working except for a value needed in a table. I would think there would be a way to reference the cell in the table but the way i have parsed other values will not work because the HTML tags repeat too many times. 

How do I reference a specific cell in the table? The tire size in the image is all I need from the table. I am able to successfully parse everything else I need. The html table is below. 

[abm]

Hi @xbommer07 

This is going to be a tricky one. May I ask you that size value always have a slash '/'?

225/75R16

Thanks

[xbommer07]

@abm 

There are two different scenarios for Tire Sizes that I can see being in the email. 

There is one tire referred to as 10-20 and all other tire sizes will have a slash. 

Thanks for your help. 

[abm]

Hi @xbommer07 

Try to do a split expression using delimiter as '</td>'. This can only works if your table format is always same. 

If you struggling post your HTML table (currently you shown as image) as text. I will try and send you something.

Thanks

[xbommer07]

@abm 

I thought of doing a split and found some good examples of it. I am not quite sure how to specify which </td> to reference as there are so many, and the value just before it changes very frequently. 

This is the HTML for the complete table. 

<td colspan="2"><table border="1" cellpadding="0" cellspacing="0" style="margin-top:8px; font-size:14px; margin-bottom:8px; margin-left:20px; color:#3056a7; font-family:Arial,sans-serif"><tbody><tr><th>Service Type</th><th>Defect</th><th>Position</th><th>Cause of Failure</th><th>Size</th><th>Tire Type</th><th>Retread Brand</th><th>Product</th></tr><tr><td>Tire Service&nbsp;</td><td>Replace Tire&nbsp;</td><td>Tractor Drive Right Front Inside&nbsp;</td><td>Tires- Unserviceable</td><td>275/80R22.5&nbsp;</td><td>Retread&nbsp;</td><td>Goodyear&nbsp;</td><td>&nbsp;</td></tr><tr>

[abm · Accepted solution]

Hi @xbommer07 

Like I mentioned earlier if your table is fixed you can use the below

The expression I used above are:

split(outputs('Compose'),'</td>')

outputs('Compose_2')[4]

replace(replace(outputs('Compose_3'),'<td>',''),'&nbsp;','')

Here is my result

Thanks

[xbommer07]

@abm 

This worked great. Thank!