cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jforsythe
New Member

How do I populate SharePoint list columns with data from body of .html email?

Need to create a flow that handles the following:

 

  1. Customer fills out online form: name, email, phone, type of issue - drop down, comments
  2. Online form sends .html email to Outlook Group inbox
  3. Email contents are added to respective columns/fields in SharePoint list (name, email, phone, type of issue, comments)
  4. List item is assigned to a staff member (based on 'type of issue') and notification is sent to Teams (or by email)

I can get the entire email added to a column, but am having trouble figuring out how to pull the individual data from the email.

 

I'm not able to edit anything about the incoming email coming from a 3rd party vendor.

 

Thanks in advance for any help/direction.

1 REPLY 1
anupam8555
Helper V
Helper V

Hello @jforsythe,

 

Here is option/my view :

 

1) If you are getting data into sharepoint list than you can fetch using sharepoint connector as well.

 

2) second, you need to parse email you received in group mailbox using flow . 

 

Thanks

 

If this helps , please mark this answer as resolved to help others.

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,253)