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 / Extracting text from e...
Power Automate
Unanswered

Extracting text from email (can't get split to work)

(0) ShareShare
ReportReport
Posted on by 25

Hi All, 

I have been banging my head against my desk for a while now and wanted to see if maybe someone could help me.  I have an email coming in that I am trying to pull customer info out of and store into a table.  I have watched several videos and read forums and everyone seems to be doing it the same way in general by converting html to text, creating a new line delimiter using the enter key, and then splitting into an array using the Enter Key delimiter.  I have done this as many ways as I can come up with and for whatever reason, my split lines keeps coming back with everything in the same line.  I cannot figure out why everyone else's I see breaks each down by line and mine is keeping them all on one.   Obviously since my data isn't getting to be split into an array I am not able to pull the data in based off of the row number.  Hopefully this makes sense but please let me know if any clarification is needed.  Thank you!!

 

Below is the expression I am using in splitIntoLines:

split(outputs('Html_to_text')?['body'],outputs('newLine'))
 
I have also tried this expression with the same results:
split(body('Html_to_text'),outputs('newLine'))
 
aalexand_0-1705950603125.png

 

Test Results:

aalexand_1-1705950629767.png

 

aalexand_2-1705950648546.png

 

Categories:
  • Matthy79 Profile Picture
    4,188 Super User 2024 Season 1 on at

    Split creates an array and as far as I can see, you have an array. Why do you think you don’t?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 423

#2
11manish Profile Picture

11manish 308 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 177

Last 30 days Overall leaderboard