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 tex...
Power Automate
Unanswered

Parsing Email body text line by line into Sharepoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

 

What I am trying to do seems simple: I would like to parse the text of an email body line by line into specific columns in a Sharepoint list.

 

The emails themselves will already be ready to parse; there won't be any need to trim out text. For example, users know that the first line in the body needs nothing but an "Owner" and the second line needs nothing but a "Customer." An example body would look something like this:

 

John Smith

Jane Doe

 

Where the first line is John Smith and second being Jane Doe.

 

Thank you for your help!

Categories:
  • ScottShearer Profile Picture
    25,331 Most Valuable Professional on at

    @Anonymous 

    I can show you how to do this but I believe it is not a great way to proceed because:

    • You would need to parse out email signatures, images, etc.
    • You can never rely on end users to format the emails the way you want them to

    Have you considered using something like Forms to collect the data rather than email?  Taking the data input in Forms and creating a SharePoint list item is a very easy thing to do.

     

     

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @ScottShearer 

    Thanks for the reply! I suggested using Forms to my organization but they are insistent on keeping this within emails.

    They will be enforcing a very simple and specific format to the emails where the Subject will act as a 'Title', the first line as 'Name', and second line as 'Customer'.

     

    Any help in achieving this specific format would be greatly appreciated.

    Thanks!

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 424

#2
11manish Profile Picture

11manish 328 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard