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:
- Search for logic app in the marketplace:
- Then, you will have to provide all the required values for your instance, including the following:
- Resource group
- 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:
- 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:
- Traditionally, you will have to sign in to integrate the external service with your application in Azure:
- 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:
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: https://docs.microsoft.com/en-us/office365/servicedescriptions/office-365-service-descriptions-technet-library). 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:
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.