Power Apps and Microsoft Flow for Share Point

Power. Apps and Microsoft Flow for Share. Point Developers Brian T. Jackett Sr. Premier Field Engineer, Microsoft

Thank you to our sponsors!

Join us for Share. Pint! When: Tonight, 4: 00 pm-6: 00 pm Where: 3 rd Street Bar 4626 3 rd Ave, Detroit, 48201 First 50 drinks on us! (Based on participation)

Sr. Premier Field Engineer at Microsoft Share. Point Dev / Admin, Power. Shell Stir Trek Conference Board Member Blog: www. Brian. TJackett. com Twitter: @Brian. TJackett Email: Brian. Jackett@Microsoft. com

https: //github. com/Brian. TJackett/BTJ. Power. Apps. Azure. DBSample

Power. Apps Data Connectors Custom API / Gateway Common Data Model Microsoft Flow Tips and Tricks

Power. Apps • Does not replace Info. Path (Forms Services) • Integration with Share. Point (Online) Microsoft Flow • Does not replace Workflow Manager today • Similar to If This Then That (IFTTT. com) • Also integrates with Share. Point (Online)

Saa. S apps enterprise services business systems Connect across your data from the cloud to on-premises

Saa. S 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

Saa. S apps mobile tablet enterprise services desktop 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

Deployment Targets • Mobile (i. OS, Android*, Windows Phone*, Web**) • Tablet / laptop

Power. Apps Data Connectors Custom API / Gateway Common Data Model Microsoft Flow Tips and Tricks

45+ pre-defined data sources (in preview)

Simple CRUD operations • Create • Read • Update • Delete • …similar to Business Connectivity services

Power. Apps + Share. Point Gateway Microsoft Flow IFTTT Integration

Added to new Share. Point List experiences • Essentially a “view” on the list

Power. Apps Data Connectors Custom API / Gateway Common Data Model Microsoft Flow Tips and Tricks

Define your own API • Swagger-based • Connect to data sources not already defined • LOB app • Internal Web API • Etc. Swashbuckle (Nu. Get) • Convert existing API Controller to Swagger document • Tip: Uncomment “Enable. Swagger. UI” in Swagger. Config. cs

Connect to on-prem data • Same technology used by Power BI, Power. Apps, and MS Flow

Supports… • Share. Point 2016 • SQL Server 2016 Machine should always be accessible Can’t install on a domain controller

Share. Point + Power. Apps Gateway Microsoft Flow IFTTT Integration

Power. Apps Data Connectors Custom API / Gateway Common Data Model Microsoft Flow Tips and Tricks

Organizational database in the cloud • Entities define domain language • People = Employee, Team, Contractor… • Sales = Customer, Contact, Sales Order… • Able to define custom entities • Create relationships between entities Id Customer. Name Title Locale Customer. Id Order. Date Price

Power. Apps Data Connectors Custom API / Gateway Common Data Model Microsoft Flow Tips and Tricks

Previously called Logic Flows • Rich workflows connected to services • Conditional logic • Templates -or- from scratch • Simplified version of Azure Logic Apps

Share. Point Integration • Connect to a Share. Point List

Trigger examples • Recurrence • Power. Apps control selected • File / email / contact created Action examples • Create file / event / contact • Send email / tweet

Power. Apps + Share. Point Gateway Microsoft Flow IFTTT Integration

Examples • Create file on reoccurring schedule

Azure Active Directory based • Name or email • View or Edit permissions No personal accounts… today Separate data connections • Target user leverages their own data connection • Prompted for choice when launching app

Power. Apps + Share. Point Gateway Microsoft Flow IFTTT Integration

Example • Capture picture with phone camera • Post to Instagram • Send to One. Drive (IFTTT) • Pick up image in Microsoft Flow • Store record in SQL Azure (Flow) • Notification via email (Flow) • Display SQL table on Azure website • API Controller on SQL to Swagger to Custom API • Custom API used in Power. Apps

Power. Apps Data Connectors Custom API / Gateway Common Data Model Microsoft Flow Tips and Tricks

• Don’t use spaces in column names (blah_x 0020_blah) • Duplicated connections from logic flows • Account connected to source • In Preview = not everything works 100% today

• Keep passwords in connections updated

http: //aka. ms/BTJPADemo

http: //aka. ms/azureicons