I have an email coming from my Asana software providing a summary of my project status update. Now asana has no connection to power automate when it comes to status updates, but I know I can read the data from the email and then get my own status update and use it in a report for myself. I have tried formatting the HTML of the email and changing it to text and was successful, but the formatting in the email (bulletpoints and new lines) basically lose there formatting and then you just get a bunch of text. It would be great to have a way to keep the formatting and getting the summary part as data. Here is what it looks like more or less:
<p>[Asana URL]New
Status update: Test. You're receiving this email because you are a collaborator
on this Status update. If you want to stop receiving notifications about this,
leave this Status update.
New Status update for Project X
View in Asana
[Asana URL]
Test
[https://s3.amazonaws.com/profile_photos/923857516817889.RT96IHSTIWBHd9lqj1d6_60x60.png]
Gideon Sep 9
Status
● On track
Project
Demand to Deliver (Plant & Machinery)
Owner Gideon
Summary
* Test
Test2
View in Asana
[Asana URL]
Logo of Asana
[Asana URL] Company Name </p>
Now the word 'Summary' is always where the update starts. I want everything from after that until the end of 'Test2'. My current approach uses counting characters between characters and then getting that, but I lose the formatting and don't know how to add it. Then I end up with multiple things just next to one another:
* Test Test