cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seaside44
Frequent Visitor

Email Parsing HTML To Text (Multiple People)

Hi,

Any idea how I would use Power Automate to parse an email to update a SharePoint list when the email is setup like the following  email body below?  I plan to read the shared inbox for the emails that contain a certain subject line.
Each email could have 1 or more person's information in it.  Each person's info is separated by " -----------------------------------------------"

I want to take that person's information and add a separate entry per person in the list (EMP NO, EMP NAME, TERM DATE).   I know I would use the html to text function, but I'm not sure how to handle the rest of it.  Any help would be greatly appreciated! 

 

Email Body: 

EXTERNAL: Be CAUTIOUS, particularly with links or attachments.

The following individuals have separated as of XX-XXX-XX.

 

  -----------------------------------------------

  EMP NO:       123

  EMP NAME:     Doe, John W

  HIRE DATE:    XX-XXX-XXXX

  TERM DATE:    XX-XXX-XXXX

  JOB:          Redacted-

  ORG:          Redacted

  LOCATION:     Redacted

  STATE:      XX

  REASON:

* -----------------------------------------------

  EMP NO:       456

  EMP NAME:     Doe2, Jane

  HIRE DATE:    XX-XXX-XXXX

  TERM DATE:    XX-XXX-XXXX

  JOB:          Redacted-

  ORG:          Redacted

  LOCATION:     Redacted-

  STATE:      XX

  REASON:

  -----------------------------------------------

 

seaside44_0-1659626873699.png

Thank you

Mike

 

1 ACCEPTED SOLUTION

Accepted Solutions
seaside44
Frequent Visitor

Well, I figured it out.  It's not the cleanest solution (takes 30 seconds to run). But, if anyone is stuck on the same problem, then I can share more details on what I did.  

View solution in original post

3 REPLIES 3
seaside44
Frequent Visitor

Well, I figured it out.  It's not the cleanest solution (takes 30 seconds to run). But, if anyone is stuck on the same problem, then I can share more details on what I did.  

Hi @seaside44,

Glad that you have resolved your problem.

Could you please mark your reply as an answer to help more users?

Thanks for your cooperation.

Best Regards,
Qi
EJenn
Frequent Visitor

@seaside44 I'm running into a similar issue of having multiple records in an single email.... do you mind sharing your solution? Thank you!

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,346)