Automating business processes with SharePoint, Office 365 and Azure

A session at SQLSaturday Cambridge 2015

Thursday 10th September, 2015

8:30am to 5:30pm (GMT)

Many people are forced to use Microsoft® SharePoint® because it is already there or part of the Office 365™ ecosystem; therefore many users see it just as another task to add to their burgeoning workload of tasks they have to complete in their busy working day. When any technology is introduced into a business it should help not hinder users. It should enable users to do more, not less. Technology should meet business needs and not be focused around a single product.

With this in mind, Penny will look at automating business processes using out-of-the-box functionality of SharePoint and with the use of Azure™ Logic Apps outside SharePoint, beyond firewalls and beyond even your own datacentre. You can create these workflows using no-code visual designers.

SharePoint topics that will be covered in this session include:

Identify when to use alerts, RSS feeds, content approval, SharePoint workflows and event receivers.
SharePoint Workflow Engines.
Workflow considerations: SharePoint on-premises and SharePoint Online
Understand the terms: workflow template, workflow, workflow instance, triggers, association and initiation pages.
Review the out-of-the-box workflow templates.
Building workflows with SharePoint Designer.
Basic building blocks: Stages, Loops, App-only Step and the Completion Condition on Parallel blocks, conditions, actions, variables.
Leveraging REST.
Other tools to build SharePoint workflows.
Access web apps 101.
Using Access macros within Access web apps and how they relate to SQL Server triggers and stored procedures.
The future: discussion of SharePoint 2016 related announcements.
Azure related topics that will be covered in this session include:

Azure Services 101.
Architecture underlying the Logic Apps engine.
API Apps, Connectors, triggers, actions.
Creating workflows using the graphical designer:
“Hello World” example using the File connector.
Using the SharePoint Online and SharePoint Server connectors.
How to best take advantage of the different Logic App capabilities.
At the end of the session you should be able to create Access web apps and your own workflows using SharePoint Designer or the Azure Portal.

Penny will provide attendees with step by step documentation of all the major demonstrations.

About the speaker

This person is speaking at this event.
Penny Coventry

Microsoft MVP SharePoint Server, Consultant, Author and Trainer

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 8:30am5:30pm GMT

Date Thu 10th September 2015

Session Hash Tag


Short URL


Official session page


View the schedule


See something wrong?

Report an issue with this session