Integrating Office 365 with Azure Logic Apps

If you have access to Office 365, you probably see the value of integrating things such as meetings, emails, and OneDrive files with Azure services. This can greatly enhance the capabilities of your company, as you can implement extra functionalities that may help in either managing the applications or monitoring them by closing the gap between a deployed application and a developer.

In this section, we will see the capabilities of Azure Logic Apps when it comes to Office 365, and what can be achieved with this service. To get started, you will need an instance of Azure Logic App. To get it, follow these steps:

  1. Search for logic app in the marketplace:

Fig. 10.34 – Logic App in Azure Marketplace
  1. Then, you will have to provide all the required values for your instance, including the following:
    • Name
    • Location
    • Resource group
    • Subscription
  2. The last step is clicking on the Create button. After a few seconds, your application should be up and running.

Now, let’s start integrating Office 365 with Azure Logic Apps, with the help of the following steps:

  1. When you access your brand new Azure Logic App, you will be offered a bunch of different recipes to get started. We can, for example, get started with emails received by your Outlook account:

Fig. 10.35 – Recipe for connecting to Outlook
  1. Traditionally, you will have to sign in to integrate the external service with your application in Azure:

Fig. 10.36 – Connecting to Office 365
  1. When you click on the Sign in button, you will be able to provide the credentials for your Office 365 account. Once the credentials are provided and your account is connected, you will be able to configure the feature:

Fig. 10.37 – Configuring the application

Of course, you are not limited to Outlook only—you can integrate other Office 365 applications such as Forms, Excel, or OneDrive (see this link for a services description: By selecting the desired Office 365 service and integrating it with an Azure logic app, you are making a connection between those two cloud components. In this section, we selected Outlook as the ingredient of the application so that we can easily introduce a logic based on incoming email messages.

The integration is based on the credentials you provided, which means that if you want to avoid connecting your account with Azure Logic Apps, you will have to enter a username and a password for an artificial user account. Depending on the service you selected, the way your logic app works will differ slightly. In my case, when I get a message sent to my Outlook account, this will be noticed and the flow of my application will start. This opens multiple interesting possibilities:

  • I can initiate a process depending on the mail subject or content.
  • I can automatically delete or move an email.
  • I can approve something somebody is asking me in a message.

There are multiple options available that you can use:

Fig. 10.38 – Available options for Outlook
Integrating Office 365 with logic apps may require additional permissions. If your connection works but you cannot add any action to your application, make sure your Azure AD account can manage email messages. See the following connector reference for more information:

In the Further reading section, you can find the details of the connector for Office 365. Take a look at that article so that you can build better applications based on this particular logic apps connection. It will give you deeper insights into the structure of the connector and the properties that it offers. Let’s now do the last exercise using Azure Logic Apps, where you will see how to integrate with Azure SQL Server.

Related Articles

How to add swap space on Ubuntu 21.04 Operating System

How to add swap space on Ubuntu 21.04 Operating System

The swap space is a unique space on the disk that is used by the system when Physical RAM is full. When a Linux machine runout the RAM it use swap space to move inactive pages from RAM. Swap space can be created into Linux system in two ways, one we can create a...

read more

Lorem ipsum dolor sit amet consectetur


Submit a Comment

Your email address will not be published. Required fields are marked *

17 − six =