Save specific Email to Excel File using Azure Logic App

Azure Logic Apps

Logic App is a cloud-based service that allows us to react to an event in one service (such as SharePoint online) and do something with the data from that event into another service (such as Twitter). It makes it practical and simple for business processes. The users build workflows that automatically perform some business tasks and processes across applications and services. We can connect our business-critical apps and services with Azure Logic Apps, automating our workflows without writing a single line of code.

Before reading this article, please go through some important article links mentioned below.

• Deep Dive Into Azure Logic Apps
• Connect OneDrive To Google Drive With Azure Logic Apps
• Connect Facebook To Twitter With Azure Logic App
• Connect Outlook Mail To Excel Sheets With Azure Logic App
• Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
• Connect Box To OneDrive Using Azure Logic Apps
• Save Only A Positive Tweet To Excel Spreadsheet Using Microsoft Cognitive
• Using Cognitive Service Face API with Azure Logic App
• Convert Tweet Into Audio File Using Cognitive Service With Azure Logic App
• Using Cognitive Service Computer Vision API, Text Analytics API With Azure
• Get Daily Weather Reports Delivered To Your Phone Using Azure Logic Apps
• How To Retweet A Specific Tweet With An Approval Email In Azure Logic App

Prerequisites

• Microsoft Azure Account

Here, we are going to see how to move the specific email to specific Excel File using Azure Logic App

Steps to build a Workflow using a template

Follow the below steps to build a Workflow using a template.

Step 1

• Log into https://portal.azure.com/.
• In the dashboard, choose to create a resource and click on Integration. Now, select "Logic App".
  

Step 2

• Enter the name you want to assign to the logic. Select the subscription and resource group where you organize the related resources and location where your logic app is stored. Then, click on "Create".
  
• Here is the dashboard. Click "Logic App Designer".
  

Step 3

Now, click on the Blank Logic App.

Step 4

Configure the Email by signing into the Outlook.

• Search for Outlook in the search bar.
  
• Choose the Triggers.
  
• Sign into Outlook.
  
  

Step 5

Configure the values.

• Choose the Folder.
  
• Then, Add parameter Subject Filter as specific keyword (Eg. Sales).
  
• Finally.
  

Step 6

Configure Excel - OneDrive

• Then choose an operation as Excel.
  
• Choose Add Row.
  
• Connect OneDrive account with this logic apps.
  
• Then, choose Folder, Table and Parameter.
  
• Finally
  

Step 7

The final workflow will be like this.

Now, let us save and run the workflow.

Output. Run the Logic App.

Its successfully run.

Just sent the demo mail with specific keyword and refresh it to see the result.

Now, received the email.

Finally, it successfully runs and moves the specific email to Excel -OneDrive.

Summary

I hope you understood how to move the specific email to Excel-OneDrive File using Azure Logic App. Stay tuned for more Logic App articles.