Brian T Jackett Sr Premier Field Engineer Microsoft Thank you to our sponsors Join us for SharePint When Tonight 400pm600pm Where 3rd Street Bar 4626 3rd Ave Detroit 48201 ID: 698692
Download Presentation The PPT/PDF document "PowerApps and Microsoft Flow for SharePo..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
PowerApps and Microsoft Flow for SharePoint Developers
Brian T. Jackett
Sr. Premier Field Engineer, MicrosoftSlide2
Thank you to our sponsors!
Slide3
Join us for
SharePint!
When:
Tonight, 4:00pm-6:00pm
Where:
3rd Street Bar
4626 3rd Ave, Detroit, 48201
First 50 drinks on us!
(Based on participation)Slide4
Brian T. JackettSr. Premier Field EngineerMicrosoftPowerApps and Microsoft Flow for SharePoint DevelopersSlide5
Sr. Premier Field Engineer at MicrosoftSharePoint Dev / Admin, PowerShellStir Trek Conference Board MemberBlog: www.BrianTJackett.comTwitter:
@BrianTJackettEmail: Brian.Jackett@Microsoft.com
About MeSlide6Slide7
Session Objectives and TakeawaysSession Objectives: What are (and what aren’t) PowerApps and Microsoft FlowHow to integrate with enterprise and consumer data sourcesHow to leverage custom APIs and data sourcesKey Takeaways:Expand horizon of tools and processes for interactionDemo scenarios for when to use PowerApps / Microsoft FlowDemo code: https://github.com/BrianTJackett/BTJ.PowerApps.AzureDBSample
Slide8
Slide 8 of <46>Slide9
Tweet: #BTJPADemo …-or-Instagram: #BTJPADemoInteractive Demo for LaterSlide10
Agenda
PowerApps
Data Connectors
Custom API / Gateway
Common Data Model
Microsoft Flow
Tips and TricksSlide11
Room meet Elephant
I’m not the InfoPath / workflow replacement you are looking for.Slide12
PowerAppsDoes not replace InfoPath (Forms Services)Integration with SharePoint (Online)Microsoft FlowDoes not replace Workflow Manager todaySimilar to If This Then That (IFTTT.com)
Also integrates with SharePoint (Online)PowerApps ComparisonsSlide13
New landscape of SharePoint dev…Slide14
New landscape of SharePoint dev…Slide15
Connect across your data from the cloud to on-premises
SaaS apps
enterprise services
business systems
Why
PowerApps
?Slide16
SaaS apps
enterprise services
business systems
Connect
across your data from the cloud to on-premises
Create
business apps with
easy visual tools and powerful cloud services
Why
PowerApps
?Slide17
mobile
tablet
desktop
SaaS apps
enterprise services
business systems
Connect
across your data from the cloud to on-premises
Create
business apps with easy visual tools and powerful cloud services
Share
securely with your team across devices
Why
PowerApps
?Slide18
Mobile / touch friendlyConnect to data sourcesUse Excel and PowerPoint skillsDevelopers can expose custom APIsWhat is PowerApps?Slide19
Deployment TargetsMobile (iOS, Android*, Windows Phone*, Web**)Tablet / laptopPowerApps OverviewSlide20
Agenda
PowerApps
Data Connectors
Custom API / Gateway
Common Data Model
Microsoft Flow
Tips and TricksSlide21
45+ pre-defined data sources (in preview)Data ConnectionsSlide22
Simple CRUD operationsCreateReadUpdateDelete…similar to Business Connectivity services
Data ConnectionsSlide23
DemosPowerApps + SharePoint
Gateway
Microsoft Flow
IFTTT IntegrationSlide24
Added to new SharePoint List experiencesEssentially a “view” on the listPowerApps + SharePointSlide25
Agenda
PowerApps
Data Connectors
Custom API / Gateway
Common Data Model
Microsoft Flow
Tips and TricksSlide26
Define your own APISwagger-basedConnect to data sources not already definedLOB appInternal Web APIEtc.Swashbuckle (NuGet
)Convert existing API Controller to Swagger documentTip: Uncomment “EnableSwaggerUI” in SwaggerConfig.cs
Custom APISlide27
Connect to on-prem dataSame technology used by Power BI, PowerApps, and MS FlowOn-Premises Data GatewaySlide28
Supports…SharePoint 2016SQL Server 2016Machine should always be accessibleCan’t install on a domain controllerOn-Premises Data GatewaySlide29
DemosSharePoint + PowerApps
Gateway
Microsoft Flow
IFTTT IntegrationSlide30
Agenda
PowerApps
Data Connectors
Custom API / Gateway
Common Data Model
Microsoft Flow
Tips and TricksSlide31
Organizational database in the cloudEntities define domain languagePeople = Employee, Team, Contractor…Sales = Customer, Contact, Sales Order…Able to define custom entitiesCreate relationships between entities
Common Data Model
Id
Title
CustomerIdOrderId
CustomerName
Locale
CustomerId
OrderId
OrderDate
PriceSlide32
Agenda
PowerApps
Data Connectors
Custom API / Gateway
Common Data Model
Microsoft Flow
Tips and TricksSlide33
Previously called Logic FlowsRich workflows connected to servicesConditional logicTemplates -or- from scratchSimplified version of Azure Logic AppsMicrosoft FlowSlide34
SharePoint IntegrationConnect to a SharePoint ListMicrosoft FlowSlide35
Trigger examplesRecurrencePowerApps control selectedFile / email / contact createdAction examplesCreate file / event / contactSend email / tweet
Microsoft FlowSlide36
DemosPowerApps + SharePoint
Gateway
Microsoft Flow
IFTTT IntegrationSlide37
ExamplesCreate file on reoccurring scheduleMicrosoft FlowSlide38
Azure Active Directory basedName or emailView or Edit permissionsNo personal accounts… todaySeparate data connectionsTarget user leverages their own data connectionPrompted for choice when launching app
Sharing PowerAppsSlide39
DemosPowerApps + SharePoint
Gateway
Microsoft Flow
IFTTT IntegrationSlide40
ExampleCapture picture with phone cameraPost to InstagramSend to OneDrive (IFTTT)Pick up image in Microsoft FlowStore record in SQL Azure (Flow)Notification via email (Flow)Display SQL table on Azure websiteAPI Controller on SQL to Swagger to Custom API
Custom API used in PowerAppsIFTTTSlide41
Agenda
PowerApps
Data Connectors
Custom API / Gateway
Common Data Model
Microsoft Flow
Tips and TricksSlide42
Don’t use spaces in column names (blah_x0020_blah)Duplicated connections from logic flowsAccount connected to sourceIn Preview = not everything works 100% todayTips and TricksSlide43
Keep passwords in connections updatedTips and TricksSlide44
Go here:http://aka.ms/BTJPADemoInteractive Demo for LaterSlide45
In Review: Session Objectives and TakeawaysSession Objectives: What are (and what aren’t) PowerApps and Microsoft FlowHow to integrate with enterprise and consumer data sourcesHow to leverage custom APIs and data sourcesKey Takeaways:Expand horizon of tools and processes for interactionDemo scenarios for when to use PowerApps / Microsoft FlowSlide46
Q&ACredits:
Icons from Microsoft AzureCloud and Enterprise Symbol / Icon Setfrom http://aka.ms/azureicons