cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Resolver II
Resolver II

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (5,842)