Get a record from table and send email

[nagoor]

Dear experts, 

Hope everyone doing good in this pandemic period.

I have a below scenario to execute in the project, i would like to get an idea what is the best way to use it in real time. 

1) We are receiving an Health check report once in 2 hours in a HTML - Web file.  

2) In that a specific table has list of alarm active in the server are captured.

3) I have saved those attachment in One-drive path and linked Power Bi to extract the data in that table. 

4) we have list of alarm number that need to alerted to support team. 

Now - the question here is, how we can use Power Automate to capture the required alarms which need actions and send a mail with the details in either attachment (or) body of the mail to support team.   

Can anyone help me on, how we can achieve this with the help of Power Automate. 

[manuelstgomes]

HI @nagoor 

I hope all is going well with you also. Take care, please.

Regarding your question, is tricky, but have you tried the "Convert HTML to text" action? 

If it's not a solution, I found another post in this forum that can help you:

https://powerusers.microsoft.com/t5/Using-Flows/Is-there-a-way-to-parse-HTML-table-output/td-p/28600...

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel