You’re offline. This is a read only version of the page.
55
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.
Share
Report
All responses (
Answers (
