web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parsing Email Body for...
Power Automate
Unanswered

Parsing Email Body for specific values

(0) ShareShare
ReportReport
Posted on by 12

I am trying to create a automated task where once a email is received, The contents of the body are extracted and put into values for each appropriate property

This is what each email that is received will be formatted as 

 

Welcome to Super View Test
Please login to your account using the details below

Username: Tbqa6@superviewexample.com
Temporary password: 580bee1f
URL: https://qa2.superviewexample.com

Registration Details submitted:

First Name: Test
Last Name: IOS
Phone Number: undefined
Company: IOS Test 1

 

And I believe this is what it will be formatted as in HTML to Text 

<p>Welcome to Super View Test Please login to your account using the details below</p>

<p>Username: Tbqa6@superviewexample.com Temporary password: 580bee1f URL: https://qa2.superviewexample.com</p>

<p>Registration Details submitted:</p>

<p>First Name: Test Last Name: IOS Phone Number: undefined Company: IOS Test 1</p>

 

I would like to be able to extract Username and populate the property email, First Name populates the firstname property, Last Name  populates the lastname property, Phone Number populates the phone number property and Company populates the company property.

This is the flow That I have so far and I am not entirely sure  if this is the best way to go about this. Any feedback would be appreciated here.

 

Trebarne_0-1607977693625.png

 

Categories:
I have the same question (0)
  • Paulie78 Profile Picture
    8,422 Moderator on at

    Ideally you would post a sample of the html email received here (before it has been converted to text). And a list of every property you want to extract.

    Be sure to use the Insert/edit code sample button in the toolbar before posting the HTML.

  • Trebarne Profile Picture
    12 on at

    Thanks for the Feedback Paulie! I have edited the question to include all the properties I want and I believe  I have inserted what I believe the HTML of the Email will render as.

     

  • Paulie78 Profile Picture
    8,422 Moderator on at

    ok, I've sort of built your answer already, but these questions/solutions are highly dependant on the input being consistent etc. That is why I asked for the HTML input of the email. Based on what you have written above I still have the same concern. Your HTML example of:

    <p>Welcome to Super View Test Please login to your account using the details below</p>
    
    <p>Username: Tbqa6@superviewexample.com Temporary password: 580bee1f URL: https://qa2.superviewexample.com</p>
    
    <p>Registration Details submitted:</p>
    
    <p>First Name: Test Last Name: IOS Phone Number: undefined Company: IOS Test 1</p>

    produces output nothing like what you have suggested the output is of: 

    Username: Tbqa6@superviewexample.com
    Temporary password: 580bee1f
    URL: https://qa2.superviewexample.com
    
    Registration Details submitted:
    
    First Name: Test
    Last Name: IOS
    Phone Number: undefined
    Company: IOS Test 1

    So, which one is accurate? If that what is the output of the HTML to Text action looks like, I will give you a solution that works for that. But it would totally not work if the HTML input was like the example you have suggested, Are you following me?

  • Trebarne Profile Picture
    12 on at

    Sorry for the confusion here. So my output will be same every time for every email that is received.  I went ahead and tried to reverse engineer one of the emails that I have received  and use a text to HTML generator and I received  this 

    <p>Welcome to Super View Test Please login to your account using the details below</p>
    
    <p>Username: Tbqa6@superviewexample.com Temporary password: 580bee1f URL: https://qa2.superviewexample.com</p>
    
    <p>Registration Details submitted:</p>
    
    <p>First Name: Test Last Name: IOS Phone Number: undefined Company: IOS Test 1</p>

     

    So I believe this is what will be outputted in my HTML to text  flow. I apologize I am still fairly new to this.

  • Paulie78 Profile Picture
    8,422 Moderator on at

    Go into your run history, click on the HTML to Text action and look at the "Inputs" section. This will contain the source HTML which I need to accurately recreate your scenario.

  • Trebarne Profile Picture
    12 on at

    So I don't have to any example runs/history as of yet as there has not been any emails. Sorry I was not prepared as I should of been for this. I am trying to get generate some run history now and trigger the job

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard