introduction to microsoft flow : power to the people (serge luca, isabelle van campenhoudt)
TRANSCRIPT
![Page 1: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/1.jpg)
Introduction to Microsoft Flow : Power to the
PeopleSERGE LUCA, ISABELLE VAN CAMPENHOUDT
SHAREQL, BRUSSELS
![Page 2: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/2.jpg)
SPONSORS
![Page 3: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/3.jpg)
Serge Luca10 x SharePoint MVP, Brussels
SharePoint since 2002
Architect (Admin, Dev, gouvernance)
Managing partner of www.shareql.com
Worked for the MS workflow team
Blog: http://sergeluca.wordpress.com/
@sergeluca
![Page 4: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/4.jpg)
Data Platform MVP, Brussels
Consultant, speaker, trainer, comunity leader
Managing partner de www.ShareQL.com
SQL Server since 1999
Blog: http://thesqlgrrrl.wordpress.com/
@thesqlgrrrl
Isabelle
Van Campenhoudt
![Page 5: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/5.jpg)
Get the session recording:https://channel9.msdn.com/events/Wydarzenia-Polskiej-spoecznoci/SharePoint-Saturday-Warsaw-2017/Microsoft-Flow-introduction-and-advanced-scenarios
Ask questions now on :
#collabsummitflow
![Page 6: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/6.jpg)
Flows and on premises
Environment + Data Loss prevention
Extensibility : communication with the outside world
Logic Apps
Prices & Roadmap
Creating Flows
Introduction : the context
Conclusions
![Page 7: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/7.jpg)
Introduction : the context
![Page 8: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/8.jpg)
Empower power users
Connect data across apps
More efficient developersApp Services
Service Fabric
Azure Functions
…
Logic Apps
API Management
BizTalk
…
SQL Server BI
Data analytics
Internet of Things (IoT)
…
The context : business Apps
Build modern business app fast
![Page 9: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/9.jpg)
Creating Flows
Introduction : the context
![Page 10: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/10.jpg)
Creating and managing FlowsMicrosoft Account (free) or Office 365 or Dynamics 365 or Flow (paid) or PowerApps ( or free new PowerApps Community Plan)
Flow.microsoft.com
Powerapps.microsoft.com
A modern SharePoint Online list
Mobile app (iOS and Android, Windows Mobile is coming)
![Page 11: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/11.jpg)
Designing a Flow
template or
from scratch
Choose a
trigger
Add
« actions »Save the flow
![Page 12: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/12.jpg)
demoEXPENSE REPORT
![Page 13: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/13.jpg)
Flows and on premises
Creating Flows
Introduction : the context
![Page 14: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/14.jpg)
Flow and data on Premises
• Install the « on Premises data gateway »(shared between PowerBI, PowerApps and Azure Logic
Apps)
![Page 15: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/15.jpg)
demoFLOW AND DATA ON PREMISES
![Page 16: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/16.jpg)
Flows and on premises
Environment + Data Loss prevention
Creating Flows
Introduction : the context
![Page 17: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/17.jpg)
Why« environments » ?
• Isolated spaces where Flows/Data are running/stored– Ex HR, Marketing, Production, Legal, DEV, TEST,
UAT, PROD…
• Different rules (DLP)– Ex marketing can use twitter, Legal and
Production cannot
• Different regions if needed
![Page 18: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/18.jpg)
Flow Administration Center
![Page 19: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/19.jpg)
![Page 20: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/20.jpg)
demoENVIRONMENTS & DLP
![Page 21: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/21.jpg)
Flows and on premises
Environment + Data Loss prevention
Extensibility : communication with the outside world
Creating Flows
Introduction : the context
![Page 22: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/22.jpg)
Extensibility : communication with the outside world
Action Request
Custom Connector (REST API described in a Swagger ) Action Http
PowerApps calls Flow
A custom app calls Flow
PowerBI calls Flow (Data Alerts)
Flow calls the outside world
![Page 23: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/23.jpg)
demoPOWERAPPS CALLS FLOW
![Page 24: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/24.jpg)
demoA CUSTOM APPLICATION CALLS FLOW
![Page 25: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/25.jpg)
demoFLOW CALLS THE OUTSIDE WORLD
![Page 26: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/26.jpg)
FLOW & POWER BI
FLOW
DATA ALERTS
DATA SOURCES
POWER BISCHEDULED REFRESH
STREAMING DATA
LIVE
![Page 27: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/27.jpg)
demoFLOW & POWERBI
![Page 28: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/28.jpg)
demoPOWERBI CALLS FLOW (data alerts)
)
![Page 29: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/29.jpg)
Flows and on premises
Environment + Data Loss prevention
Extensibility : communication with the outside world
Logic Apps
Creating Flows
Introduction : the context
![Page 30: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/30.jpg)
Logic Apps
More dev oriented(Json, Rest api, Visual Studio …)
Logic Apps connectors can be used in Flow
Exceptions : B2B connectors B2B (Very good integration with Biztalk Server)
The workflow engine behind Flow is Logic Apps
![Page 31: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/31.jpg)
demoLogic Apps
)
![Page 32: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/32.jpg)
Flows and on premises
Environment + Data Loss prevention
Extensibility : communication with the outside world
Logic Apps
Prices & Roadmap
Creating Flows
Introduction : the context
![Page 33: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/33.jpg)
Tarifs: Comparison
![Page 34: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/34.jpg)
Tarifs: Comparaison
![Page 35: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/35.jpg)
Q3 Calendar 2016
Q4 Calendar 2016
oAndroid Mobile App
oOn-premise data Gateway
oIn-context in SharePoint
Online
oFlow SDK for Embedding
oAdvanced control-flow logic
oMicrosoft Common Data
Model support
oGeneral availability, 42
languages, 7 geographies
oAppSource integration
oIn-context in Dynamics 365
oLeverage device signals (e.g.
Location)
oData Loss Protection Policies /
Admin management
oCo-Authoring
H1 Calendar 2017
o Sovereign cloud availability
(Government Cloud,
Germany, French Cloud)
o Seamless grow-up from
Microsoft Flow to Azure
Logic Apps
o ALM: Move solutions across
environments
o Azure functions integration
![Page 36: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/36.jpg)
Approval Roadmap
![Page 37: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/37.jpg)
Flows and on premises
Environment + Data Loss prevention
Extensibility : communication with the outside world
Logic Apps
Prices & Roadmap
Creating Flows
Introduction : the context
Conclusions
![Page 38: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/38.jpg)
Positive
• Simple
• Not just SharePoint
• Connection to hundreds of services
• Including on prem!
• SharePoint Integration
• PowerApps, PowerBI integration
• Team very proactive & delivers
![Page 39: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/39.jpg)
Negative
• Young, unknown reliability
• Cannot copy flow across environments
• No state machines (but we have loops and tests)
• Collect feedback weak
• SharePoint integration weak (no lookup,…)
![Page 40: Introduction to Microsoft Flow : Power to the People (Serge Luca, Isabelle Van Campenhoudt)](https://reader031.vdocuments.us/reader031/viewer/2022022415/5a64b6e27f8b9ac21c8b4c25/html5/thumbnails/40.jpg)
Advices
• Keep your forms as simple as possible
• Manage the business logic in the workflow
• Learn the Logic Apps Workflow DefinitionLanguage (WDL)– Read my blog post
https://sergeluca.wordpress.com/2017/04/26/using-the-azure-logic-apps-workflow-definition-language-in-microsoft-flow-part-1/