Forward email form entries into SharePoint Lists

, , ,

EmailToSharePointA common requirement for our customers is to forward emails to SharePoint Online lists. This email data usually comes from website forms or enquiry pages, though there’s no out-of-the-box way to extract the form data from an email, and upload it to separate columns in SharePoint list.

Previously I was using Cloud2050 Email Sync, though it relied on software installed on a PC to work, and only worked while that PC was operational and Outlook was open.

Here’s a solution that operates completely in the cloud using Outlook Rules, MailParser.io and Microsoft Azure Logic Apps.

The solution looks like this:

  1. Office 365 forwards email from your website’s form to your mailparser.io address via an Outlook Rule or Exchange Transport Rule.
  2. MailParser.io receives the email, extracts the form data and sends it to an Azure logic app using a Generic HTTP Webhook.
  3. Your Azure Logic App receives the form data, connects to SharePoint Online and adds the form data into the appropriate SharePoint list columns.

Prerequisites:

  • Sign up for MailParser.io – a free 30 day trial is available
  • Sign up for Microsoft Azure – use your Office 365 account, a free 30 day trial is available
  • A SharePoint List set up with the fields required for your form

Setting up MailParser

  1. Once you’ve signed up for mailparser.io, sign in and click Create New InboxCreate New Inbox In Mailparser.io
  2. Give it a name and add some notes:Name Mailparser Inbox
  3. You’ll be given an email address to forward your form emails to. Keep track of this address, as you’ll need it to receive the emails you send from Outlook or Exchange mail rules. Forward a couple of sample form emails to the address to get started.Get Mailparser Email
  4. Once your emails are received, you can set up your Parsing Rules:Add Mail Parsing Rules
  5. Usually, the mailparser will be able to automatically identify the field names and values from your forwarded email. If it doesn’t, click Try Something Else to give it some help, otherwise click OK, start with this.Automatic Mail Parsing Rule Set Up
  6. Now, we start setting up our Generic Webhook. Click Webhook Integrations in on the left menu, then click Add New Integration.
    Click Webhook Integrations
  7. Click Generic Webhook.Click Generic Webhook
  8. Give it a descriptive name and type in a sample URL (I used http://google.com) into the Target URL field. We need to use a sample first so that we can copy the webhook’s JSON payload. We then use this JSON payload to help generate the actual TargetURL from Azure Logic Apps in the next steps.Save And Test Webhook With Sample URL
  9. Next, click Save and test.
  10. Then Send test data. We expect this to fail, though it will give us the JSON payload.Send Test Data With Sample URL
  11. Copy the text from Body Payload into Notepad or Visual Studio Code.Sample URL Fails, Get Body Payload

Set up the Azure Logic App

  1. Log onto Azure at portal.azure.com. If you don’t already have a subscription, you can sign up using your Office 365 account.
  2. Click New, search for Logic App, and click Logic AppSearch For Logic App
  3. Click CreateCreate Logic App
  4. Complete the fields, placing the Azure Logic App in the region of your choice. You can name the Resource group whatever you like, or use an existing one. Click Create.Enter Logic App Details
  5. Click Edit to start editing your logic app.Edit Logic App
  6. Search for Request and click the Request TriggerCreate Request Trigger
  7. Now you can use your copied JSON Body Payload from MailParser.io as a reference for your Request Body JSON Schema.You’ll need to define the data type for each Key-Value Pair in your JSON payload. This allows you to use the separate fields in your Azure Logic App, and add the field data into the appropriate SharePoint columns.The syntax of the Request Body JSON Schema is as follows:
{
    "type": "object", 
    "properties": {
        "name": {
            "type" : " string"
            },
        "email": {
            "type" : " string"
            }
    },  
    "required":["name", "email"]
} 

You can use Visual Studio Code, Notepad++ or Notepad to edit this schema so that it describes your JSON Payload.

Replace the properties values with the name of the keys in your JSON payload. Not all fields need to be added to the required array, only the ones that you need to create a valid SharePoint list entry.

In my case, this JSON body becomes the following JSON Schema.JSON Body In Visual Studio Code
JSON Request Body Schema

  1. Paste the Schema into the Request Body Schema and click Save.Save Request To Get POST URL
  2. You will then receive the URL that you can use in Mailparser.io to send your requests:
  3. Next click + New step.Add New Step To Logic App
  4. Type SharePoint and click SharePoint – Create item.Create SharePoint List Item
  5. You may need to add a Connection to SharePoint Online. If you’re prompted, add a connection using an Office 365 account that has permission to write to the required SharePoint list. If you don’t have a SharePoint list available to accept the data, you’ll need to set one up now before proceeding.
  6. Next enter your site URL. The List Name drop down will be populated with the available lists. You should also see that the Outputs from the Request step are available to use.Enter SharePoint Site And List Details
  7. The list columns that can accept strings, as well as a few other column types will be available for you to modify. Click in each relevant column and select the relevant output.Add Outputs To SharePoint List
  8. Once you’re finished, go back to the Request Step in your Logic App and copy the URL from the Request stepCopy Request URL
  9. Return to MailParser.io, go back to Webhook integrations, and click Edit.Edit Webhook Integration
  10. Paste the URL from your Logic App Request step into the Target URL.Update Webhook Target URL
  11. Click Save and test.
  12. Click Send test data.Test Custom Webhook
  13. You should receive a response code of 202 to confirm it was sent successfully.Confirm Webhook Works
  14. You can now check Azure Logic Apps to confirm that it ran correctly.Logic App Runs Correctly
  15. You should also see the new entry in your SharePoint Online list.New Item In SharePoint

Setting up the Outlook Rule

Once you’ve confirmed it’s working, you can set up your mail rules in Outlook or via Exchange to automatically forward emails to your mailparser.io email address.

  1. Right click on an email sent via your web form. Click Rules, then Create rule.Right Click Rules Create Rule
  2. Choose a condition that matches all emails sent via your form, eg. Subject. Then click Advanced Options…Tick Subject Click Advanced Options
  3. Click Next.Click Next On Outlook Rule Wizard
  4. Tick forward it to people or public group, then click people or public group.Forward To People Or Public Group
  5. Enter the email address from Mailparser.io, click OK, then click Next twice.Paste Email From Mail Parser
  6. Turn on the rule, and choose whether you want to run it on mail already in the same folder.Turn On Outlook Rule

And that’s it. From now on, any mail sent by your website’s form will be automatically forwarded into mailparser.io, broken up into the relevant fields, and added to SharePoint Online. You can also use Azure Logic Apps to automate a bunch of other business processes. Check out the documentation here.

Similar services to Azure Logic Apps include Microsoft Flow, Zapier and IFTTT.

Data Location

Act now to move your Office 365 data to Australia

Microsoft has delivered Office 365 from their Australian datacenters since the end of May 2015.

It was a big deal at the time, and it’s still a major selling point for their cloud platform, especially amongst businesses that have strict data residency requirements.

If you’ve purchased Office 365 since May 31, 2015 with an Australian billing address, you’ll be accessing your services from the Australian datacenters already. If you purchased it before then, some of your services might have moved automatically, though some may still be delivered from the Asia Pacific region.

If you’d like to move, be quick – the option is only available until October 31, 2016.

How to request a move to Australia’s datacenters

To make sure your organisation’s data is being hosted in Australia, or to request a move, follow these instructions.

  1. Log into the Office 365 Admin portal as a Global Administrator
  2. Click Settings then Organization Profile
    Organization Profile
  3. See your current Data locationData Location
  4. To move your data click Edit under Data residency optionData Residency Option
  5. Click the switch to Yes, then click SaveChanging Your Data Residency Option
  6. Within 12 months from October 31 2016, your data will be migrated to the Australian datacenters. You will be notified once it’s complete.Data Migration Confirmation

Since it’s a complex operation, no exact date for your migration can be given. See this link for more info: https://msdn.microsoft.com/en-us/library/dn878163.aspx

Simplify External Contact and Group Management with Powershell

,

Connect To PowerShell First

We have a couple of customers that want to maintain distribution groups of external contacts that can be used company wide.

The way to do this as an Exchange admin is to create a Mail Contact for an external user first, and then add that mail contact to a distribution group. This can be quite an involved process, and you may not want to have users traversing the Exchange Admin Center to complete this sort of task.

To make this easier, we’ve put together a power shell script that you can download here.

Assign the minimum permissions

Any Global administrator will be able to run this powershell script, though if you want to give a user the ability to execute the commands, you’ll need to assign them to the appropriate role groups. These are Recipient Management and Organization Management. Keep in mind, even though these are the minimum permissions required to run this Powershell script, they still enable the relevant user to do pretty much everything within Exchange. For a full list of the permissions granted, see these links:

To give a user the correct permissions, connect to Exchange Online via Powershell as a global administrator and run the following commands. Replace user@domain.com with the identity of the relevant user.

Add-RoleGroupMember "Recipient Management" -Member user@domain.com
Add-RoleGroupMember "Organization Management" -Member user@domain.com

Running the PowerShell Script

Once the user has been granted access they can run the powershell script under their own credentials.

  1. Download the script here. 
  2. Rename it with a file extension of .ps1 eg. DistributionGroups.ps1
    Rename Distribution Groups To DistributionGroups.ps1
    DistributionGroups.Ps1
  3. Run the script by right clicking the file and choosing Run in PowershellRight Click to Run With Powershell
  4. Press 1, then Enter to connect to Exchange Online. Press Enter again once the commandlets have downloaded.Connect To PowerShell First
  5. Follow the menu items within the PowerShell script to perform the following actions:
  • Add Mail Contacts to distribution groups
  • Get a list of distribution groups
  • Create a distribution group
  • Get a list of distribution group members
  • Remove a contact from all distribution groups
Information Rights Management In Office 365

Use Information Rights Management to protect data on Office 365

,

Information Rights Management In Office 365
In the past few months we’ve put together a few Data Rooms for our clients – virtual places where internal and external parties can be invited to view confidential, or commercially sensitive data. One of the features of Office 365 that’s allowed us to protect these files is Information Rights Management.

What is Information Rights Management?

Information Rights Management is a feature that is only available on the Enterprise Office 365 Plans. It allows you control the security of your data, and prevent users from printing, marking up your documents or even accessing them after a specified period of time. When used in conjunction with the existing security features of SharePoint Online or OneDrive for Business, Information Rights Management can be used to lock down your important and sensitive data quite comprehensively.

Who can use it?

In order to get this set up, you must be using an Office 365 Enterprise plan, like Office 365 E1, Office 365 E3, Office 365 E4 or Office 365 E5.

Office 365 Small Business, Small Business Premium, Midsize Business, Business Essentials, Business or Business Premium miss out on the extra security measures available in Information Rights Management.

How to set up Information Rights Management in Office 365

Information Rights Management is not enabled by default, it needs to be manually configured. Here’s how it’s done.

  1. Log into Office 365 as an administrator at https://portal.office.com.
  2. If you’re not already taken to the Office 365 Admin center, click the App Launcher on the top left, then click the Admin tile.Open Office 365 Admin Center
  3. Under Service Settings, click Rights Management.Click Rights Management In Office 365 Admin Center
  4. Click Manage, under Protect your information.Click Manage To Enable Information Rights Management
  5. Click Activate, to activate Rights Management for your organisationActive Information Rights Management
  6. Click Activate again.Click Activate To Enable Information Rights Management
  7. Wait for Rights Management to activate.Wait For Information Rights Management To Activate
  8. Navigate to the SharePoint Admin Center, by clicking SharePoint under Admin, on the left menu.Open SharePoint Admin Center
  9. Click Settings in the SharePoint admin center.Open SharePoint Admin Center Settings
  10. Click Use the IRM service specified in your configuration, then Refresh your settings.Use The IRM Service Specified In Your Configuration
  11. Wait for the settings to be applied.Refresh Your IRM Settings
  12. Navigate to the SharePoint Document Library that you want to apply Information Rights Management to, then click the Library tab at top, followed by Library Settings.Open Your Document Library Settings
  13. Under Permissions and Management, choose Information Rights Management.Navigate To Information Rights Management
  14. Tick the box to restrict permissions on this library on download. Then, give your Permission Policy a name and a description that you’d like to appear for the users. Choose the settings of the policy for this document library.Set Information Rights Management Policy Settings
  15. Any Office documents uploaded to this document library will have the IRM policy added when they are opened or downloaded. If you would prefer that users cannot download documents, and can only view them in the browser, give them View Only permission in SharePoint Online.See Information Rates Management Applied To Documents

A note about Information Rights Management and PDF files

In our experience, Information Rights Management works best when working with Office documents, because they can be securely opened in the browser and don’t have to be downloaded to the computer. PDF documents can also have IRM policies applied to them, though since there is no way to open these in the browser, they must be downloaded and opened with a PDF reader that supports IRM. There are a couple of options for this, though the experience may not be ideal for the user who is accessing the data, since they may have to install a supported PDF reader.

For the best user experience, you may decide to secure PDF files using the dedicated PDF security features. You can still store these PDFs on SharePoint Online on OneDrive, though it is best to keep these in a separate document library without IRM applied.

Alternatively, you can convert your PDF documents to Word Documents, for consistent IRM policies and security for all of your files.

Exchange Online

Secure the devices that access your Office 365 email

,

Exchange Online

One of the conditions of setting up an Exchange Account on a mobile phone or tablet is that the Exchange administrator has control over that device’s security features. If you’re new to administering Exchange, the level of control that you get over these connected devices may surprise you.

Here’s a few things that you can do.

  • Enable/Disable the camera
  • Enable/Disable WIFI
  • Enable/Disable Internet Tethering
  • Enable/Disable the device’s web browser
  • Enable/Disable personal, POP or IMAP email accounts
  • Enable/Disable the use of storage cards
  • Enable/Disable text messaging
  • Require a password on the device
  • Require a password after a defined period of inactivity

To get this working, there are two main steps.

  1. Create a Mobile Device Mailbox Policy
  2. Apply the Mobile Device Mailbox Policy to the relevant users

How to create your Mobile Device Mailbox Policy

  1. Open PowerShell on your computer
  2. Connect to Exchange Online via PowerShell. Follow our quick guide to get this set up.
  3. Build your New-MobileDeviceMailboxPolicy cmdlet, or use one of our samples below. For more information, refer to the documentation at https://technet.microsoft.com/en-us/library/jj218612(v=exchg.160).aspx
  4. Paste and Run your New-MobileDeviceMailboxPolicy cmdlet. For example:
    New-MobileDeviceMailboxPolicy -Name "No Camera Policy" -AllowCamera $false

How to assign your mobile device mailbox policy to users

To assign the new policy to users, use the Set-CASMailbox cmdlet. See this link for the complete documentation:
https://technet.microsoft.com/en-us/library/bb125264(v=exchg.160).aspx

To use this cmdlet, ensure you are connected to Exchange Online via Powershell

Assign the Policy to all users

Get-Mailbox -ResultSize Unlimited | Set-CASMailbox -ActiveSyncMailboxPolicy "Your Policy Name"

Assign the policy to a specific user

Set-CASMailbox -Identity elliot@gcits.com.au -ActiveSyncMailboxPolicy "Your Policy Name"

Confirm that your policy was added correctly

To make sure your policy was applied successfully run this:

Get-CASMailbox -identity elliot@gcits.com.au | fl *

You should see the policy name next to ActiveSyncMailboxPolicy:Applied Mobile Device Policy

A few minutes after running the policy, you should see it take effect on the relevant devices:

Disable Camera Via Office 365

Camera Disabled Via Office 365

Revert back to the default policy

You can revert back to the default policy by running the following:

Set-CASMailbox -identity elliot@gcits.com.au -ActiveSyncMailboxPolicy "Default"

Sample Policies

Use these sample policies or create your own. These sample policies only use one parameter eg. -AllowCamera $false, though you can add as many parameters to a policy as you like. See this link for the complete list of available parameters: https://technet.microsoft.com/en-us/library/jj218612(v=exchg.160).aspx

Disable a mobile device’s camera

New-MobileDeviceMailboxPolicy -Name "No Camera Policy" -AllowCamera $false

Disable a mobile device’s WIFI

New-MobileDeviceMailboxPolicy -Name "No WIFI Policy" -AllowWifi $false

Disable Internet tethering on a mobile device

New-MobileDeviceMailboxPolicy -Name "No Tethering Policy" -AllowInternetSharing $false

Disable the web browser on a mobile device

New-MobileDeviceMailboxPolicy -Name "No Browser Policy" -AllowBrowser $false

How to login to Office 365

When you’re getting started with Office 365, you might find our Office 365 for Beginners videos to be helpful. Feel free to watch the video and read the summary below.

Your Office 365 account = Your identity

Office 365 works best when everybody in the team has an Office 365 account – and your account is everything to you in Office 365, it’s your identity, and when it comes to working in the cloud, your identity and the security of that identity is really important. It doesn’t matter if you share mailboxes, or files, or responsibilities with another person, because that can all be accounted for and easily configured. The bottom line is, having your own Office 365 login is essential.

Portal.office.com

There are a few different ways to login to Office 365, though my personal favourite is via https://portal.office.com. Because that takes you to your Office 365 Portal and you can get to everything from here.

Personal vs Work or School?

Microsoft provide two types of accounts. There’s Personal Accounts and there’s Work or School accounts. Unfortunately these aren’t the only two names that these accounts go by. Personal Accounts are also called Live IDs or Microsoft Accounts. Work or School accounts are also known as Office 365 accounts, Organisational accounts or even Azure Active Directory accounts. But basically, Personal accounts are accounts for consumers and you use them to log into consumer level services like the regular Skype, or Xbox Live or Outlook.com. Work or School accounts are accounts that are given to you by your work or school. And you’ll primarily use them to sign into the Office 365 services.

The tricky part is, these two accounts can be used to log into the same applications and services, and you can have the same email address associated with both types of accounts which is the case with mine.

Work or School or Personal accounts

I have signed up for a Microsoft account, or a Personal Account, with my Work or School email, and I also have an Office 365 account. So when I put my email address in, occasionally it will say Work or School, or Personal account? And If you’ve signed up for a Personal Microsoft account using your work or school email and you also have Office 365 for work or school, you’ll probably see this too.

So you need to pay attention, is this particular login screen asking for a personal account, or a work or school account, or is it asking for either. The general rule of thumb is, if you’re using Office 365 for work or school, choose a ‘Work or school’ account.

Inside the Office 365 Portal

Office 365 Portal

Once you’re logged into Office 365, you can do quite a lot from inside the portal. Here’s what you get.

  • Install Office for PC or Mac

    Install Office at the top of the portal – This one may not be common to most people, though if you’ve got an Office 365 account that gives you the desktop versions of Office, you can install it for PC or Mac by clicking ‘Install now’.

  • Mail, Calendar, People and Tasks

    The first three tiles Mail, Calendar, People, and the one below called Tasks, are your email, your calendars, your contacts and your tasks. You can work with them from here through the browser, or through Outlook, or on your phone or tablet.

  • Yammer

    Next is Yammer. This is a social network for your business. It’s just like an internal Facebook.

  • Sites

    SharePoint Online is under Sites. SharePoint sites are places where your team can collaborate on projects and share information.

  • OneDrive

    OneDrive for Business is your personal cloud file storage. It’s private to you, though you can share things from it.

  • Delve

    Delve is your Office 365 search engine, it also helps you discover what’s everyone’s working on in Office 365.

  • Video

    Think of Office 365 Video as an internal YouTube that you can use for training videos, meeting recordings or any video material that needs to stay internal.

  • Power BI

    If you’ve signed up for the Power BI Add-on, you’ll see it in the portal too. Power BI Pro is costs extra, though if understanding data is important to your business, it’s absolutely worth it. The free version also lets you accomplish quite a bit.

  • Office Online

    Word, Excel, PowerPoint, OneNote are the Online versions of the Office programs that you can use to work on your files over the internet, even if you don’t have Office installed.

  • Sway

    Sway is pretty similar to PowerPoint, use it to present information in ways that look really nice on all devices.

 

So we’ve covered logging into Office 365, the difference between a Personal Account and a Work or School account, and we’ve touched on a few of the common Office 365 services. If you think that’s all you need to get started, you can go ahead and dive right in. But if you do want to dive a little deeper on some of these services you can go ahead and check out some of our other videos or articles.

PowerApps

Start getting excited about PowerApps and Office 365

 A new way to build powerful business applications

If you think you haven’t got what it takes to build a mobile app for your business, think again. Microsoft PowerApps fill a huge gap in the development of business applications – and you can use them to automate your tedious manual processes.

Typically, If you need a custom app built for internal use, you’ll take this to your internal IT department, or outsource it to an external development team. Software developers will then use tools like Microsoft Visual Studio to build these apps to your requirements.

The process to take your app idea from concept to a finished product that can run on PCs and devices is extensive and expensive. So much so, that many teams will use a combination of existing tools like Excel, SharePoint or OneNote to achieve similar results. This can work well when you’re using a PC or Mac, though what if you really need to build an app that runs well on a mobile device? You use Microsoft PowerApps.

PowerApps allow you to uniformly design your own mobile applications and the logic behind them. These powerful applications run on Apple, Android and Windows devices and connect to almost any data-source imaginable.

So now, instead of approaching a software development team with a list of requirements, you open PowerApps and start building. Once you’ve created your application, you can share it with anyone on your team.

It’s important to note that PowerApps are for building internal tools only. Though, while you can’t share these with the public, they can be used in public facing scenarios, such as survey collection, or event signups.

Data that PowerApps can work with so far:

  • Excel
  • Dropbox
  • Dynamics CRM Online
  • Google Drive
  • OneDrive
  • SalesForce
  • SharePoint Online
  • Dynamics ERP
  • SQL Server
  • SharePoint Server
  • Any custom datasource you configure!

Some PowerApps you can build:

  • Company asset manager
  • Budget Tracker
  • Conference Agenda
  • Instruction Manual
  • Service Desk
  • Survey collection and reporting
  • Event sign-ups
  • Opportunity tracking
  • Product Catalog

How to get started with PowerApps

If you’re interested in getting started with PowerApps and Office 365, you might have to wait for your invite. PowerApps are currently in private preview, though you can sign up for your invitation here.

 

Office 365 apps for Windows Phone

Office 365 apps for Windows Phone

Office 365 Apps for Windows Phone

Office 365 apps for Windows Phone

Office 365 is a powerful productivity platform that allows you to get more done from any device. Here’s a list of apps from Microsoft that help you make use of Office 365 while you’re on the go.


  • Mail and Calendar

    The new Mail and Calendar app for Windows Phone is an updated version of the earlier built-in mail app. It’s a Universal Windows App, so it runs on all Windows devices, including PCs. It doesn’t have the same Focused Inbox as the iOS/Android versions, though it does have some cool swipe functionality.



  • OneNote


    OneNote is the one place for everything in your life. Use it to plan projects, keep meeting minutes, take notes, organise trips and keep track of important info. Spend a few moments with OneNote on any of your devices and it will quickly become your favourite app. We cannot speak more highly of OneNote, it’s a must have for any Office 365 user.


  • Word

    Create, Edit and Share Word documents on the Microsoft Word App for Windows phones and tablets. Microsoft Word is one of the top rated productivity apps on the Google Play Store due to its rich feature-set, ease of use and ability to open documents from various cloud services and locations.



  • Excel

    Excel has made the transition to mobile devices with style. The new dedicated Excel App lets you create, edit and share Excel Documents. The new Excel app on Windows Phones and tablets is a huge improvement over the converged Office Mobile app that was previously available.



  • PowerPoint

    Create, Edit and Share PowerPoint presentations from your Windows phone or Tablet. The new PowerPoint app for Windows Phones and Tablets is a big step up from the combined Office Mobile App.



  • OneDrive

    The OneDrive app lets you add both consumer and business OneDrive accounts, and work with your files from anywhere. Browse your files, and those shared with you. Quickly access recent documents, or search your entire OneDrive. Open your OneDrive files in your Office Apps, and automatically save them back to OneDrive.



  • Skype for Business

    Skype for Business, formally known as Lync, does exactly what the name suggests – it gives you Skype for your business. Use the mobile app to stay in touch with your team members and regular Skype contacts from your Windows Phone.



  • Yammer

    Yammer is a social network for your business. Post announcements, share praise, run polls and gather feedback. Yammer is a great alternative for group conversations via email, is integrated across Office 365, and has a great Windows Phone app.



  • Outlook Groups

    Outlook Groups are the new way to work as a team in Office 365. Create an Outlook Group to get a group email address, feature-packed newsfeed, OneNote notebook and document storage. Outlook Groups for Windows Phone gives you that functionality on the go.



  • Office Lens

    Office Lens is a cool app that lets you take photos, or use existing ones, and convert them into PDFs, editable Word Documents, OneNote Pages or PowerPoint Presentations. Take photos of Documents and Whiteboards, and let Office Lens do the rest.



  • Office Remote

    Office Remote for Windows Phone lets you control your PowerPoint presentations from your Phone. You can start or stop presentations, advance slides, view speaker notes and more. You also get to control your Word and Excel documents remotely while you present them on a screen or your computer.



  • Power BI

    The Power BI for Windows devices app lets you view and interact with your Power BI dashboards from anywhere. You can set alerts on important data, and get notified when targets are hit or not met. If you’re not familiar with Power BI, check it out now. We think it’s the most exciting addition to Office 365 available.



  • Office 365 Admin

    This is a must have app for any Office 365 Administrator. Use the Office 365 Admin app to add, edit, block or delete users, reset passwords, assign licenses, check on the Office 365 service status and much more. You can also log support requests and sign into multiple Office 365 organisations from the same app.


Office 365 apps for Android

Office 365 apps for Android

Office 365 Apps for Android

Office 365 apps for Android

Office 365 is a powerful productivity platform that allows you to get more done from any device. Here’s a list of apps from Microsoft that help you make use of Office 365 while you’re on the go.


  • Outlook

    We recommend the Outlook for Android app when using Office 365 on an Android Phone or Tablet. It gives you an awesome feature called Focused Inbox, allows you to reschedule email for later reminders, and customise simple swipe shortcuts to better organise your inbox.



  • OneNote


    OneNote is the one place for everything in your life. Use it to plan projects, keep meeting minutes, take notes, organise trips and keep track of important info. Spend a few moments with OneNote on any of your devices and it will quickly become your favourite app. We cannot speak more highly of OneNote, it’s a must have for any Office 365 user.



  • Word

    Create, Edit and Share Word documents on the Microsoft Word App for Android phones and tablets. Microsoft Word is one of the top rated productivity apps on the Google Play Store due to its rich feature-set, ease of use and ability to open documents from various cloud services and locations.



  • Excel

    Excel has made the transition to mobile devices with style. The new dedicated Excel App lets you create, edit and share Excel Documents. Use it in conjunction with the Keyboard for Excel to really up your Excel productivity while mobile.



  • PowerPoint

    Create, Edit and Share PowerPoint presentations from your Android phone or Tablet. Presenter view, an exclusive feature for Office 365 subscribers, allows you to check your speaker notes on your phone or tablet, and control the presentation running on your PC. The new PowerPoint app for Android is a big step up from the combined Office Mobile App. After 100 000 reviews, it’s sitting at 4.4/5.



  • OneDrive

    The OneDrive app lets you add both consumer and business OneDrive accounts, and work with your files from anywhere. Browse your files, and those shared with you. Quickly access recent documents, or search your entire OneDrive. Open your OneDrive files in your Office Apps, and automatically save them back to OneDrive.



  • Skype for Business

    Skype for Business, formally known as Lync, does exactly what the name suggests – it gives you Skype for your business. Use the mobile app to stay in touch with your team members and regular Skype contacts from your Android phone or tablet.



  • Yammer

    Yammer is a social network for your business. Post announcements, share praise, run polls and gather feedback. Yammer is a great alternative for group conversations via email, is integrated across Office 365, and has a great Android app.



  • Outlook Groups

    Outlook Groups are the new way to work as a team in Office 365. Create an Outlook Group to get a group email address, feature-packed newsfeed, OneNote notebook and document storage. Outlook Groups for Android gives you that functionality on the go.



  • Sunrise

    Microsoft bought Sunrise, the best calendar app for Android, in Feb 2015. Sunrise combines calendars from Office 365, Outlook.com, Google, Facebook, your TV show schedules, your favourite sport teams schedule, and much more. Sunrise also provides an easy way to decide on a time to meet people via your phone.



  • Office Lens

    Office Lens is a cool app that lets you take photos, or use existing ones, and convert them into PDFs, editable Word Documents, OneNote Pages or PowerPoint Presentations. Take photos of Documents and Whiteboards, and let Office Lens do the rest.



  • Delve

    Delve uses your Office 365 data and machine learning to help you discover what your team members are working on across Office 365. You can use Delve to search for people, projects and documents across Office 365.



  • Office Remote

    Office Remote for Android lets you control your PowerPoint presentations from your Phone. You can start or stop presentations, advance slides, view speaker notes and more. You also get to control your Word and Excel documents remotely while you present them on a screen or your computer.



  • Power BI

    The Power BI for Android app lets you view and interact with your Power BI dashboards from anywhere. You can set alerts on important data, and get notified when targets are hit or not met. If you’re not familiar with Power BI, check it out now. We think it’s the most exciting addition to Office 365 available.



  • Office 365 Admin

    This is a must have app for any Office 365 Administrator. Use the Office 365 Admin app to add, edit, block or delete users, reset passwords, assign licenses, check on the Office 365 service status and much more. You can also log support requests and sign into multiple Office 365 organisations from the same app.



  • Microsoft Send

    Microsoft Send is a project by Microsoft Garage, a community within Microsoft that turns ‘wild ideas into real projects’. Microsoft Send feels like texting and works like email, stripping back subjects, signatures and greetings, to give you quick simple messaging with anyone who uses email. This app is great for teams.



  • Keyboard for Excel

    Here’s another app from the Microsoft Garage team. Keyboard for Excel adds a number optimised keyboard to your Android Device. It prioritises the characters that you use the most in Excel (including a TAB key!) and is designed to give you greater speed and efficiency for data-entry on your phone.


Office 365 iPhone Apps

Office 365 apps for iPhone

Office 365 Apps for iPhone

Office 365 iPhone Apps

Office 365 is a powerful productivity platform that allows you to get more done from any device. Here’s a list of apps from Microsoft that help you make use of Office 365 while you’re on the go.


  • Outlook

    We recommend the Outlook for iOS app when using Office 365 on an iPhone. It gives you an awesome feature called Focused Inbox, allows you to reschedule mail to be reminded later, and customise simple swipe shortcuts to better organise your inbox.



  • OneNote


    OneNote is the one place for everything in your life. Use it to plan projects, keep meeting minutes, take notes, organise trips and keep track of important info. Spend a few moments with OneNote on any of your devices and it will quickly become your favourite app. We cannot speak more highly of OneNote, it’s a must have for any Office 365 user.



  • Word

    Create, Edit and Share Word documents on the Microsoft Word App for iOS. Microsoft Word is one of the top rated productivity apps on the App store due to its rich feature-set, ease of use and ability to open documents from various cloud services and locations.



  • Excel

    Excel has made the transition to mobile devices with style. The number of features they’ve packed into this iOS app is amazing, and the users agree – after 13000+ ratings, the Excel App for iOS is still over 4.5 stars.



  • PowerPoint

    Create, Edit and Share PowerPoint presentations from your iPhone or iPad. You can also use Apple Airplay to project your presentation onto a large screen, and control it from your phone or Apple Watch.



  • OneDrive

    The OneDrive app lets you add both consumer and business OneDrive accounts, and work with your files from anywhere. OneDrive for iOS lets you upload, share, and save your files for offline use.



  • Skype for Business

    Skype for Business, formally known as Lync, does exactly what the name suggests – it gives you Skype for your business. Use the mobile app to stay in touch with your team members and regular Skype contacts from your iPhone or iPad.



  • Yammer

    Yammer is a social network for your business. Post announcements, share praise, run polls and gather feedback. Yammer is a great alternative for group conversations via email, is integrated across Office 365, and has a great iPhone app.



  • Outlook Groups

    Outlook Groups are the new way to work as a team in Office 365. Create an Outlook Group to get a group email address, feature-packed newsfeed, OneNote notebook and document storage. Outlook Groups for iOS gives you that functionality on the go.



  • Sunrise

    Microsoft bought Sunrise, the best calendar app for iOS, in Feb 2015. Sunrise combines calendars from Office 365, Outlook.com, Google, Facebook, your TV show schedules, your favourite sport teams schedule, and much more. Sunrise also provides an easy way to decide on a time to meet people via your phone.



  • Office Lens

    Office Lens is a cool app that lets you take photos, or use existing ones, and convert them into PDFs, editable Word Documents, OneNote Pages, PowerPoint Presentations and even contacts. Take photos of Documents, Whiteboards and business cards, and let Office Lens do the rest.



  • Delve

    Delve uses your Office 365 data and machine learning to help you discover what your team members are working on across Office 365. You can use Delve to search for people, projects and documents across Office 365.



  • Sway

    Sway is like PowerPoint for any device. Create Sways to share ideas, information and presentations in a format that displays beautifully on any device. It uses an intuitive design engine to layout your Sway with minimal input, and lets you share it with anyone, whether they’re using Sway or not.



  • Power BI

    The Power BI for iPhone app lets you view and interact with your Power BI dashboards from anywhere. You can set alerts on important data, and get notified when targets are hit or not met. If you’re not familiar with Power BI, check it out now. We think it’s the most exciting addition to Office 365 available.



  • Office 365 Video

    Office 365 Video for iOS gives you access to your Office 365 Video Portal, formatted for your mobile device. You can use Office 365 Video to store and share training videos, your company’s mission and vision, recorded meetings and more.



  • PowerApps

    Microsoft PowerApps are coming soon, and they’re a fantastic way for anyone to build powerful business apps using their existing data. Use PowerApps to access any datasource, including SharePoint, Excel, SQL Database, custom APIs and more. Next create simple logic flows to automate business processes and present important information. Once you’re done, you share your apps with the team.



  • Microsoft Send

    Microsoft Send is a project by Microsoft Garage, a community within Microsoft that turns ‘wild ideas into real projects’. Microsoft Send feels like texting and works like email, stripping back subjects, signatures and greetings, to give you quick simple messaging with anyone who uses email. This app is great for teams.