Power Automate Parse Email Body [Excel & SharePoint List]

Recently, I was working on a Power Automate task that required me to extract data from emails and save it in a SharePoint list.

In this article, I will explain all about Power Automate read email body, Power Automate get email body text, and Power Automate parse email body with examples.

Also, we will discuss Power Automate extract data from email body to excel and Power Automate parse email body to SharePoint list.

Power Automate Extract Data from Email Body to Excel

To extract text from the email body and save it to an Excel spreadsheet, follow the below steps.

First, we need to create an Excel spreadsheet with all the details like Task Title, Task Assigned To, and Task Priority. Select the Excel shell and format it as a table, as shown in the image below:

The screenshot below displays the email with all the details that I need to save in the Excel sheet.

The Excel sheet will appear like the below:

To work around this, check out the below points:

1. Open the Power Automate Home page -> Click +Create -> Select ‘Automated cloud flow’ -> In the next window, Provide a flow name & select trigger ‘When a new email arrives (v3)’ -> Tap Create button.

Inside the trigger, select the below details:

• Folder: Select the folder as Inbox.
• Subject Filter: Provide the subject line to filter the emails received.

2. In the next step, select and add ‘Html table to text‘ action.

• Content: Select Body under When a new email arrives from dynamic content.

3. Then, select ‘Add a row into a table.’ Configure the required parameters:

• Location: Select the location where the Excel file is saved.
• Document Library: Choose the specific documents from drop-down.
• File: Select the files from the open library icon.
• Table: Choose the table name.

In the fields of excel, I will add the expression to get the data in rows of Excel.

• Task Title: @{split(split(outputs(‘Html_to_text’)?[‘body’],’:’)[1],’,’)[0]}
• Task Assigned To: @{split(split(outputs(‘Html_to_text’)?[‘body’],’:’)[2],’,’)[0]}
• Task Priority: @{split(split(outputs(‘Html_to_text’)?[‘body’],’:’)[3],’,’)[0]}

4. Once the flow gets ready, Save the flow. Click on Test-> Select Manually radio button. Click Runflow.

5. When the flow starts running, send an email with the Task Details as shown in the below figure:

6. When the flow runs successfully, you can see the task details saved in the Excel spreadsheet.

Refer to the image below:

This is how to extract text from email and parse text into the Excel spreadsheet.

Power Automate Parse Email Body to SharePoint List

To get the email text body into the SharePoint list by using Power Automate, check the below-mentioned example.

Here, I have a SharePoint list [Product Details]with a few columns, as shown in the figure below:

Example:

When an email arrives with the subject Product Details, I want to extract email content and store it in the SharePoint list.

Go through the steps:

1. Take the When an email arrives[V3] flow action and provide details like Folder and Subject Filter, as shown in the above example.

• Folder: Select Inbox of Outlook
• Subject Filter: Take Product Details

2. To extract plain text from the HTML content of the arrived email body, click on The Next step and select the ‘HTML to text‘ action.

So, in the content parameter, add the dynamic content, i.e., Body -When a new email arrives.

3. Take Compose flow action to split the information received in the email.

Inputs: Insert the below expression.

split(outputs('Html_to_text')?['body'],'|')

Here, it will split the email text based on ‘|‘ as a delimiter.

4. Now, add the Create item flow action from the SharePoint list.

• Site Address: Select a specific SharePoint site from the drop-down.
• List Name: Choose a list name under the SharePoint site.
• Title: outputs(‘Compose’)[1]
• Product Name: outputs(‘Compose’)[3]
• Product Type: outputs(‘Compose’)[5]
• Billing Date: outputs(‘Compose’)[7]
• Estimated Delivery: outputs(‘Compose’)[9]

Once the flow is completed, save and test the flow manually.

5. When an email arrives with the provided subject filter, the flow triggers and runs the flow.

6. The flow runs successfully and saves the email text in the SharePoint list.

Look at the image below:

This way, we can parse text messages from the email body to the SharePoint list using Power Automate.

Also, you may like:

• Power Automate Date Functions
• Power Automate Rename File
• Create HTML Table in Power Automate + Formatting
• Power Automate Approval Reminder
• Delete Files Older than 3 Years from SharePoint Document Library Using Power Automate
• 6 Various Ways to Sort Array in Power Automate

Conclusion

I hope this Power Automate tutorial guide is helpful and understanding. In this article, I have covered how to work with Power Automate extract data from email body to excel and Power Automate parse email body to SharePoint list with examples.

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.