building business applications in office 365 sharepoint online using logic apps

#novacodecamp @pgbhoyar

Building Business Applications in Office

365/SharePoint Online using Logic Apps

Prashant G Bhoyar (PGB)

Northern Virginia Code Camp

08 October 2016


Northern VA CodeCamp Fall 2016

is sponsored by


3

• Senior Consultant at Portal Solutions

• Born and raised in India

• Came to United States of America in 2007 for studies

• University of Maryland College Park Alumni

• Technical Reviewer of the book “Pro : SharePoint 2013 Administration”

• Organizer of SharePoint Saturday Baltimore (SPSBMORE)

• Founder and Organizer of DC-Metro Office 365 User Group Monthly in person & online event

http://www.meetup.com/DC-Metro-Office-365-User-Group/

• Recipient of Antarctic Service Medal

Who AM I ?

Prashant G Bhoyar (PGB)

http://www.meetup.com/DC-Metro-Office-365-User-Group/


Amazing Antarctica Adventure – Nov/Dec 2008


Amazing Antarctica Adventure – November/December 2008

• McMurdo Station, Antarctica (US Government Station)

• 1000-1100 people stays during Antarctic Summer (November to February)


About Portal Solutions

We deliver Digital

Workplace Products

and Solutions that help

organizations share

what they know and

find what they need by

connecting people,

data, and content.

6


OneWindow Capabilities –

Modern Intranet Out-of-the Box

Social and Mobile

experience

Collaborative workspaces

(public or private,

communities or projects)

People directory and

gateway to other

applications (my apps)

Stories and corporate

communication

publishing


OneWindow Workplace

• Built on and for Office 365 and Microsoft Azure

• Available for Office 365 and SharePoint Hybrid environment

OneWindow

YammerSharePoint

OnlineSkype For Business Office Groups Office Graph/Delve

VideosOneDrive for

Business

OneWindow APIs

Planner

Analytics


Next Steps

9

Interested in assessing if OneWindow Workplace

is right for you?

Let’s talk. Click here or go to http://www.onewindowapp.com to learn more.

http://www.portalsolutions.net/

http://www.onewindowapp.com/onewindow/contact

http://www.onewindowapp.com/


Upcoming Local Speaking Engagements

• IT Pro Camp Washington DC –15th October 2016

http://www.meetup.com/SUG-DC/

• Reston SharePoint User Group – 7th November 2016

http://www.meetup.com/Reston-SharePoint-User-

Group/events/234291739/

10

http://www.meetup.com/SUG-DC/

http://www.meetup.com/Reston-SharePoint-User-Group/events/234291739/


• What are Azure Apps?

• What are Logic Apps?

• Logic Apps Key Concepts

• Logic Apps and Office 365

• Demos

• Limitations

• Q&A

Agenda

Outcome:

Familiarity Logic

Apps

Objective: Building

Business

Application in

Office 365 using

Logic Apps


Audience Poll

• How many of you are IT pros?

• How many of you are Developers?

• How many of you are Power Users?

• How many of you are End Users?

• How many of you are already playing with Logic Apps?

13


15

How to get personal Azure Subscription?

If you have MSDN Enterprise subscription You can get $nter150/month Azure credits for free

Sign Up for Free trial : https://azure.microsoft.com/

Credit Card is required

Microsoft Imagine Former Dreamspark

No credit card required

Valid .edu account from participating school/institution

Limited feature sets

https://azure.microsoft.com/


17

How to get Office 365 Demo Tenants

Tenant?

Login at https://www.microsoftofficedemos.com/Loginusing your partner account

Get 3 months of Office 365 subscription for free

Excellent for rapid client demos

More than 20 Seats

Customer Immersion Experience (CIE) is also an option

Formerly called as MEC

1 Month Trial E3, E5

https://products.office.com/en-us/business/compare-office-365-for-business-plans

https://www.microsoftofficedemos.com/Login

https://products.office.com/en-us/business/compare-office-365-for-business-plans


19

• It is Platform as a service offering (PaaS)

• Create web and Mobile apps for any platform or device

• Integrate your apps with SaaS solutions, connect to on-premises applications and automate your business processes

• Azure runs your apps on fully managed virtual machines (VMs) with your choice of shared resources

What is Azure App Service?

Source :https://azure.microsoft.com/en-us/documentation/articles/app-service-value-prop-what-is/


API APPS

Easily build and consume APIs in the cloud

WEB APPSWeb apps that scale with your

business

LOGIC APPS

Automate business process across SaaS and on-premises

MOBILE APPS

Build Mobile apps for any device

App Service


22

• It is fully managed iPaaS(integrated Platform as a service)

• Allows developers not to have worry about building hosting, scalability, availability and management

• Scale up automatically to meet the demand

• Provides a way to implement scalable integrations and workflows in the cloud

• Many connectors are available across cloud and on premise

• Begins with the trigger

• Use with custom API apps of your own

What are Logic Apps?

Source :https://azure.microsoft.com/en-us/documentation/articles/app-service-logic-what-are-logic-apps/


Advantages of Logic Apps

• Saving time by designing complex processes using easy to understand design tools

• Implementing patterns and workflows seamlessly, that would otherwise be difficult to implement in code

• Getting started quickly from templates

• Customizing your logic app with your own custom APIs, code, and actions

• Connect and synchronize disparate systems across on-premises and the cloud

• Build off of BizTalk server, API Management, Azure Functions, and Azure Service Bus with first-class integration support

24



Why Logic Apps?

• Easy to use Design Tools

• Connect APIs easily

• Get Started quickly from templates

• Extensibility baked-in

• Real integration horsepower

26


Logic App Engine

• Can handle thousands of parallel runs per stamp

• Resilient against failure – retries with “at least once” guarantee

• Simple, declarative JSON definition

• Automatically infers dependences between actions

• Over 50 functions from string manipulations to math, to sets operations, to logical operators

• All HTTP operations supported on any arbitrary endpoint

• Supports many OAuth providers, AAD, Cert auth, or Basic auth

• Different ways to be triggered including recurrence


Logic Apps Key Concepts?

• Workflow - Logic Apps provides a graphical way to model your business processes as a series of steps or a workflow.

• Managed Connectors - Your logic apps need access to data and services. Managed connectors are created specifically to aid you when you are connecting to and working with your data. See the list of connectors available now in managed connectors.

• Trigger - Some Managed Connectors can also act as a trigger. A trigger starts a new instance of a workflow based on a specific event, like the arrival of an e-mail or a change in your Azure Storage account.

• Actions - Each step after the trigger in a workflow is called an action. Each action typically maps to an operation on your managed connector or custom API apps.

• Enterprise Integration Pack - For more advanced integration scenarios, Logic Apps includes capabilities from BizTalk. BizTalk is Microsoft's industry leading integration platform. The Enterprise Integration Pack connectors allow you to easily include validation, transformation, and more in to your Logic App workflows.

29



• Box

• Chatter

• Delay

• Dropbox

• Azure HD Insight

• Marketo

• Azure Media Services

• OneDrive

• SharePoint

• SQL Server

• Office 365

• Oracle

• QuickBooks

• SalesForce

• Sugar CRM

• SAP

• Azure Service Bus

• Azure Storage

• Timer / Recurrence

• Twilio

• Twitter

• IBM DB2

• Informix

• Websphere MQ

• Azure Web Jobs

• Yammer

• Dynamics CRM

• Dynamics AX

• Hybrid Connectivity

• Youtube

• HTTP, HTTPS

• HTTP Webhook

• FTP, SFTP

• SMTP

• RSS

• Delay, DelayUntil

• Terminate

• Workflow

• Batching / Debatching

• Validate

• Extract (XPath)

• Transform (+Mapper)

• Convert (XML-JSON)

• Convert (XML-FF)

• X12

• EDIFACT

• AS2

• TPMOM

• Rules Engine

Connectors

Protocols BizTalk Services

Built-in API Connectors


Logic App Triggers

• Recurrence

Day, Hour, Minute, Second

• Events

Create

Update


Logic App Actions

• Delay actions

• Http services: Get, Response, Webhooks

• SharePoint : Create, Edit Delete files & items

• OneDrive for Business : Create, Edit Delete files

• Calendar services: Create event

• CRM services: Create object, get objects

• Data services: Execute, get, insert

• File services: Create file, List files

• Mail services: Send, campaigns, approvals

• Message services: Get, list, send

• Social media services: Get profile, get content, post

• Translation services: Detect language, translate


{

"parameters": {

...

},

"triggers": {

...

},

"actions": {

...

},

"outputs": {

...

}

}


36

• Prerequisites

Visual Studio 2015

Latest Azure SDK (2.9.1 or greater)

Azure PowerShell

• Visual Studio 2015 Tools -> Extensions and Updates

• Select the Online category to search online

• Search for Logic Apps to display the Azure Logic

Apps Tools for Visual Studio

• Click the Download button to download and install

the extension

• Restart Visual Studio after installation

• https://visualstudiogallery.msdn.microsoft.com/e25

ad307-46cf-412e-8ba5-5b555d53d2d9 (direct link)

Logic Apps and Visual

Studio

Source : https://azure.microsoft.com/en-us/documentation/articles/app-service-logic-deploy-from-vs/

https://www.visualstudio.com/downloads/download-visual-studio-vs.aspx

https://azure.microsoft.com/downloads/

https://github.com/Azure/azure-powershell#installation

https://visualstudiogallery.msdn.microsoft.com/e25ad307-46cf-412e-8ba5-5b555d53d2d9


Logic Apps vs Flow

Logic Apps Flow

• iPaaS offering

• Pay as per the usage

• IT professional focused and built for real life scenarios

• No direct integration with modern SP list and libraries

• SaaS offering

• Currently under preview-May be bundled with Office 365 subscription

• Subset of Logic Apps and build for more power user scenarios

• direct integration with modern SP list and libraries


Logic Apps Limits and Configuration

Name Limit

Request Timeout 1 minute

Message Size 50 MB

Run duration 90 days

Actions per workflow 60

Triggers per workflow 10

Source :https://azure.microsoft.com/en-us/documentation/articles/app-service-logic-limits-and-config/


Logic Apps Pricing

• Pay only for what you use

• Per action billing

• Logic Apps procured through Volume Licensing agreements,

such as an Enterprise Agreement, receive enrollment level

discounts off of the price of the lowest volume tier.

• For Azure Direct customers, Logic Apps usage will be billed

using a volume-based tiered model

43

Source: https://azure.microsoft.com/en-us/pricing/details/logic-apps/


Logic Apps Pricing

Actions Executed/Month Price per action execution

First 250K actions $0.0008 /action

251K-1M Actions $0.0004 /action

1M-50M actions $0.00015 /action

50M-100M actions $0.00009 /action

100M+ actions $0.000054 /action

Source: https://azure.microsoft.com/en-us/pricing/details/logic-apps/


References

Appendix/Resources

Getting Started:

https://azure.microsoft.com/en-us/services/app-service/logic/

Logic App Forum on MSDN :

https://social.msdn.microsoft.com/Forums/en-US/home?forum=azurelogicapps

Pricing:

https://azure.microsoft.com/en-us/pricing/details/app-service/

https://azure.microsoft.com/en-us/services/app-service/logic/

https://social.msdn.microsoft.com/Forums/en-US/home?forum=azurelogicapps

https://azure.microsoft.com/en-us/pricing/details/app-service/


Questions? Feedback? Contact me:

Twitter: @PGBhoyar

Blog: http://pgbhoyar.com (limited contents)

Email: [email protected]

Feedback : Please provide feedback

Email or

Anonymous Suggestions: https://www.suggestionox.com/r/pgb

Thank You

Organizers, Sponsors and You for Making this Possible.

http://www.twitter.com/rharbridge

http://pgbhoyar.wordpress.com/

mailto:[email protected]

https://www.suggestionox.com/r/pgb

building business applications in office 365 sharepoint online using logic apps

Software