Services like DocuSign and Smartsheet use the Microsoft Graph to pull contextual information out of Office and put it to work where it’s most useful. Credit: Reuters/Jim Young Over the years, Office has expanded from the original desktop applications (and their mobile and Web equivalents) and the Exchange and SharePoint servers that add more business features, into full-fledged services. Many businesses treat Office 365 as an efficient way to get hosted Exchange or a cheaper way to volume licence the Office software. But they’re missing out on the advantages of Office 365 being a cloud service; like the Delve analytics that help people find out what colleagues are working on, or the Microsoft Graph API that lets you extract messages, calendar appointments or tasks to use in custom tools and software. That’s how the new Microsoft Flow service lets you build a workflow that sends a text message every time your boss emails you. Even if you haven’t noticed that Microsoft has been busy unlocking useful information in Office, other services have started using the Microsoft Graph to expose some of that outside Office. It turns out that email might not be the most useful place to see an ‘out of office’ message and your calendar isn’t the only place meetings are important. “Consuming small pieces of data here and there,” as Rob Howard from Microsoft’s Office Ecosystem team describes the Graph API, can be a big help for productivity. “Context is really valuable for a lot of things. Are you in or out of the office? Are you available? A service can search my contacts and look at whether they’re out of the office, or whether they’re available based on Skype and calendar availability,” explains Howard. Over the years, Office has expanded from the original desktop applications (and their mobile and Web equivalents) and the Exchange and SharePoint servers that add more business features, into full-fledged services. Many businesses treat Office 365 as an efficient way to get hosted Exchange or a cheaper way to volume licence the Office software. But they’re missing out on the advantages of Office 365 being a cloud service; like the Delve analytics that help people find out what colleagues are working on, or the Microsoft Graph API that lets you extract messages, calendar appointments or tasks to use in custom tools and software. That’s how the new Microsoft Flow service lets you build a workflow that sends a text message every time your boss emails you. Even if you haven’t noticed that Microsoft has been busy unlocking useful information in Office, other services have started using the Microsoft Graph to expose some of that outside Office. It turns out that email might not be the most useful place to see an ‘out of office’ message and your calendar isn’t the only place meetings are important. “Consuming small pieces of data here and there,” as Rob Howard from Microsoft’s Office Ecosystem team describes the Graph API, can be a big help for productivity. “Context is really valuable for a lot of things. Are you in or out of the office? Are you available? A service can search my contacts and look at whether they’re out of the office, or whether they’re available based on Skype and calendar availability,” explains Howard. SUBSCRIBE TO OUR NEWSLETTER From our editors straight to your inbox Get started by entering your email address below. Please enter a valid email address Subscribe “One of the most common ones we see apps consuming is the directory. How an organization is structured, who your peers are, who reports to you, who you report to; that structure drives a huge amount of business process and you can make that more efficient,” says Howard. “Or who are the people you meet with most and what are the meetings about? Just having access to the most recent files I’ve worked with is one that will find a huge number of use cases. Files in SharePoint and OneDrive, information in Exchange, tasks in our new Planner service; there’s a variety of content and a huge amount of content to drive those apps. We’re just starting to scratch the surface of how intelligence can power custom and third-party experiences.” If you’re using DocuSign to electronically sign documents and contracts, for example, and you’re using it with an Office 365 email account, DocuSign doesn’t just use that email to send documents back and forth. If you’re sending a contract to someone who’s set an out of office message, you’ll see that message in the DocuSign interface (because it gets it from Exchange Online via the Microsoft Graph) — so you know before you even send the document that there’s going to be a delay. If there’s an alternate contact listed in the out of office message, you can click on the name to send it to that person instead. If no alternate contact has been listed and you don’t have time to wait, DocuSign can suggest other people who were involved in the project who might be able to sign instead (by looking at who else at in the organization was in the same meetings with you). And even if the person you want is in the office, having DocuSign check both your address book and email addresses you’ve been in contact with recently (again, from Exchange) to make sure the email address is correct can save time and embarrassment. Just having DocuSign show you a list of the files you’ve worked on most recently — which it gets from OneDrive — is more convenient than digging through your folders, because it’s likely the file you want to have signed will be there. Microsoft Office smoke signals There are over a billion meetings every month scheduled through Office 365, says Howard; the Microsoft Graph lets the services you use take advantage of all that information. Microsoft has been using custom apps built on the Graph internally for performance management and team management, he says, and DocuSign isn’t the only partner that has already started using it in their services. “You can use data from Office, from the Graph to make a really productive experience for managing teams or moving along your business process,” he suggests. Smartsheet integrates a lot of Microsoft tools into its project management and automation service, like Power BI and Skype; you can go from analyzing the numbers on a project to calling people working on it to get a status report. You can already save email messages and attachments into a Smartsheet project from Outlook, and a new feature will let you attach files from OneDrive to a Smartsheet task without leaving the service. “Do” is a service for managing meetings, with tools for creating agendas and tracking follow-ups and action items; if you sign in to Do with an Office 365 account, it will automatically pick up existing meetings from your calendar and it uses Exchange Online to get email addresses for the names you tag with actions. Zapier is an online service that lets you automate Office 365 tasks — like sending email and creating meetings based on triggers from other systems like Box, ZenDesk, Zoho or QuickBase — or pull information into those systems. If you use Meetup or EventBrite to manage events, you can create a “Zap” that makes a new folder to handle all the email about a specific event, or if you’re using Fog Creek’s Trello for project management, you can make a Zap to create new items in Trello automatically when you get email that matches the trigger you create. Pulling information out of Office using the Microsoft Graph gives you the option of using tools that are more like the popular Slack chat system than email, if that’s what works best for your business — especially on mobile devices. As you’d expect, Howard believes the Office apps still matter: “We think for some tasks it’s important to make the solution a native part of an Office app and we can embed it in a tool people are using to get work done every day, like Outlook or Word. But there are also a bunch of cases where the appropriate tool is something that is not an Office app.” If you need to sign a document, that’s increasingly likely to happen on a mobile device. What you really want, Howard suggests, is “a tailored app on your phone that’s aware of who you are, what organization you’re part of, what document you’re signing and what the next step in the workflow is — all based on your organization’s data inside of Office. A lot of ‘smarter’ is just understanding the context of the business process; maybe automatically filling out fields in your forms because we know who you are and what business process you’re working on. Here are the documents that are relevant to you, or that you recently received or worked with in Office. On a phone, we’ve got a pretty good chance of surfacing to you the one document you want to do the signing on.” More intelligence ahead Look for the Graph API to expose more and more information in the future. “How people work with each other, the documents and topics that they’re working on — that could help when I’m sharing documents, so I know which users and groups those documents are most relevant to,” Howard says. The Graph doesn’t yet use location but that could be useful (with the right privacy options and controls): “An app could automatically send a message saying I’m going to be late, or it could help with scheduling based on a previous meeting,” he suggests. Setting up those meetings could get easier too. “Scheduling meetings and resources in general is a really difficult problem; it takes a huge amount of time, especially as people work more and more across organizational boundaries,” says Howard. “Using the Microsoft Graph, I can say ‘here are the constraints, here are the people who are critical versus optional, here’s what I want to talk about and for how long’ and it will go and look across all the calendars. There are very few apps I’m comfortable with scheduling meetings in today, because I don’t think they’d take account of who’s free and who’s busy and who needs to be involved and match up all the schedules.” What you’re really getting from the Microsoft Graph are fundamental pieces of your business process and your working life that until now have been locked inside Office. You’ll still want to work with them there, but just by writing documents, setting up meetings, exchanging email and using Skype for Business to talk to colleagues, you’re also creating useful signals and insight. That by-product of getting your job done is so useful precisely because it is a by-product, Howard points out. “If we asked people to fill out a profile it wouldn’t be useful because you would get such low engagement. If you needed to go into Skype for Business every half hour and update your presence, it would never work. Because it’s connected to signals and looking at my calendar, it can set my status in Outlook to ‘away’ because I’m in this meeting right now — and you can count on that. When we can take the signals from your usage of Office and glean that information automatically, we can get a baseline of intelligence and information across your entire organization, just because you’re using Office.” Related content brandpost Embrace the Generative AI revolution: a guide to integrating Generative AI into your operations The CTO of SAP shares his experiences and learnings to provide actionable insights on navigating the GenAI revolution. By Juergen Mueller Sep 29, 2023 4 mins Artificial Intelligence feature 10 most in-demand generative AI skills Gen AI is booming, and companies are scrambling to fill skills gaps by hiring freelancers to make the most of the technology. These are the 10 most sought-after generative AI skills on the market right now. By Sarah K. White Sep 29, 2023 8 mins Hiring Generative AI IT Skills feature Top 17 cloud cost management tools — and how to choose Cloud cost analysis tools help your organization keep on top of its overall cloud use and associated costs, which can add up rapidly. By Peter Wayner Sep 29, 2023 14 mins Cloud Management Cloud Computing news CIO Announces the CIO 100 UK and shares Industry Recognition Awards in flagship evening celebrations By Romy Tuin Sep 28, 2023 4 mins CIO 100 Podcasts Videos Resources Events SUBSCRIBE TO OUR NEWSLETTER From our editors straight to your inbox Get started by entering your email address below. Please enter a valid email address Subscribe