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.
||Thursday 10th September
||300 – Normal (attendees may require a working knowledge)
||Experienced business users, site owners, administrators or developers who want to re-engineer parts of their business processes.
||Ranging from £100.00 (Super-Early Bird) to £140.00 (Late Bird) + booking fee + VAT
||Cambridge City Hotel, Downing St, Cambridge. England CB2 3DT.
||Understand and have worked with SharePoint site components, such as, Alerts, Lists, Libraries, Content Types, Site Columns, and Permissions.
Identified aspects of your organisation’s requirements to create a collection of activities and tasks that map to specific business processes and worked with visual representations of business processes.
Although the emphasis is on no code solutions, understand program elements, such as variables, operators, conditions and the use of functions and macros such as you might find in Excel or Access.
||The session will consist of lectures and demonstrations. No laptop is required.
Penelope Coventry is a Microsoft MVP for SharePoint Server with more than 30 years of industry experience. She has authored and coauthored many books on SharePoint, including Exploring Microsoft SharePoint 2013: New Features and Functions, Microsoft SharePoint 2013 Inside Out, Microsoft SharePoint 2013 Step by Step, Microsoft SharePoint Designer 2010 Step by Step and Microsoft SharePoint Server 2010 Administrator’s Companion.
Penny is a regular speaker at SharePoint and Technical conferences around the world and when she’s not writing, she works as the Product Specialist for LightningTools and a trainer at Combined Knowledge.
SQLSaturday Cambridge pre-conference sessions
SQLSaturday Cambridge Social Media
Event News section of registration site (see right pane)
SQLCambs SQLSaturday news
SQLSaturday Cambridge on Facebook
SQLSaturday Cambridge on Google+
SQLSaturday Cambridge on Twitter follow @sqlsatcambs and use #sqlsatcambridge and#sqlsat411 hashtags.
Tenbulls blog or follow on Twitter @retracement
SQLSaturday Cambridge Information and Travel
Do you have questions about Penelope Coventry – Automating business processes with SharePoint, Office 365 and Azure?