How to Use Power Automate to Automatically Create SharePoint List Items Based on Email Content?

Question

I want to create a Power Automate flow that automatically adds items to a SharePoint list whenever an email is received.

The email contains details such as the title, description, and priority, which need to be mapped to the corresponding SharePoint list columns.

What steps should I follow to build this flow, and how can I ensure that all the data from the email is accurately added to the SharePoint list?

 

Answer 1

Extract Email Content to SharePoint List

To achieve this, follow these steps in Power Automate:

• Create a new Automated Cloud Flow.
• Use the trigger "When a new email arrives (V3)" in Power Automate.
  

• Specify the folder (e.g., Inbox) or apply filters (e.g., subject, sender) to narrow down the emails to process.
  

• Add the "Html to text" action to extract plain text from the email body if needed.
  
  > You can use the "Compose" action or "Parse JSON" action to extract specific details from the email.

• Add the "Create item" action for SharePoint.
  

• Configure the connection to your SharePoint site and select the list where the items should be created.
• Map the email fields (e.g., subject, body, etc.) to the SharePoint list columns.