Power Platform Community Forum Thread Details

Hi all,

Please could you help me with this flow that I want to create, I am trying to obtain the values of a table that they sent me by email and export them to an Excel.

The trigger is: when you receive an email, then use a variable to extract the body of the email into HTML.

Then in another variable I use: indexOf(variables('body'),'<table')

and then:

add(indexOf(variables('body'),'</table>'),length('</table>'))

In the table variable I use: substring(variables('body'),variables('indexof start'),sub(variables('End'),variables('indexof start')))

Then in the last step I am testing:

split(replace(variables('HTML table'), '</tr>', ''), '<tr>')

to eliminate the <tr that for some reason are not deleted.

I plan to remove the headers, adding a skip. but when doing so it doesn't show me anything on the body. I'm not sure what steps to follow anymore, could someone help me achieve this.

Categories:

Using flows