Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Get content in correct format from HTML email

(0) ShareShare
ReportReport
Posted on by

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard