Daniel Straitiff, DSTRAITIFF@pragmaticworks /DANIELSTRAITIFF/ @SUPERPOWERBI SUPERPOWERMYBI

1. Daniel Straitiff, DSTRAITIFF@pragmaticworks /DANIELSTRAITIFF/ @SUPERPOWERBI SUPERPOWERMYBI.com Introduction to Microsoft Flow

2. Microsoft Flow Overview What is Microsoft Flow? What problems does it solve?

3. Flow is… Workflow automation Routine and Repetitive tasks

4. Why Automation? Increase Productivity Eliminate Inconsistencies Focus on Business Critical Issues

5. Real World Use Cases Within Power Platform Power BI Power Apps Microsoft Flow

6. Business Problems, Flow Solutions Work Force Multiplication Nontechnical staff acts as citizen developers Leveraging drag and drop functionality, not code Systems Integration 225+ Connectors Custom and template solutions Regulation Administration & compliance Data Loss Prevention (DLP) policy

7. Flow’s Audience Flow focus: • Business Users & Specialists • (Office, Dynamics) Logic Apps Focus • IT Pro / Developers • (Visual Studio, Azure)

8. Extended Benefits • IT/Developers • Highly advanced and business critical Flows • Logic Apps • Any Flow can be converted to a Logic App

9. Triggers & Actions Triggers Sets the flow in motion An Event A Button Scheduled Actions What you want to happen when a trigger is invoked

10. Templates, Templates and Templates

11. At a Glance

12. Getting Started with Flow

13. Using Templates in Flow Flow Templates Connectors

14. Module 1 Flow Templates What is a Template? A pre-built flow that performs one or more tasks automatically after it is triggered by an event Can be modified to fit your specific needs Can be examined as a Learning Tool Can be uploaded to the Microsoft Flow Community for sharing

15. Module 1 Flow Templates Template Categories All Flows Sync Featured Mobile Approval Notifications Button Productivity Email Social Media Data Collection Events and Calendar Can also Search templates by service

16. Module 1 Connectors What are Connectors? Connections between servicesthat can be used as triggers and actions in Flow Must have an account for and be signed into services to utilize them Some connectors are not availableto free users (Premium)

17. Module 1 Connectors Data Explorer

18. Creating a Flow Using a Template

19. Testing and Troubleshooting Testing Flows Troubleshooting Flows Common Errors

20. Module 1 Testing Flows • Testing Flows • Test after creating or altering a flow or when issues are encountered • Testing is done in the Flow Designer • Can easily be monitored and tested any time on web or mobile • Multiple ways to Test Flows • Manual trigger action • Using Data from previous runs • Use Data from Connector Data Explorer

21. Module 1 Troubleshooting Flows • When a Flow Fails • Notifications appear when a Flow fails • Inspect the flow within the Edit Pane • Troubleshooting Resources • Monitor Flow while running • Use data from connector/previous runs • Microsoft Flow Community forums Data Explorer

22. Module 1 Common Errors Common Errors & Codes Authentication Failure (401, 403) Action Configuration (400, 404) Temporary / Transient Failures (500, 502) Identifying Errors Error Details in the Flow’s Edit pane Flow Checker

23. Testing Flows

24. Building your first flow from scratch Connectors, Triggers, Actions Demo

25. Triggers Trigger Event that kicks off the flow Microsoft Flows start with a trigger Triggers can be run manually (Buttons) Run on a schedule (Recurrence Trigger) Run based on an event 225+ Services Triggers and actions in more than 225 Services

26. Polling pattern Push Triggers Push triggers Notify Microsoft Flow when an event occurs Poll Triggers Wakes up at regular intervals and checks the service for activity. Connectors without triggers ServiceNow

27. Actions Actions One or more actions may exist inside a flow Types of Actions (Operation Types) Create Update Delete Assign Perform Action Actions can be reordered and Removed

28. Data Events When a data item is modified, created, or deleted

29. Capturing Data Captured data can be used anywhere in the flow Actions – Generate Data Actions can modify and have outputs Outputs ‘flow’ from each step and is available in later steps Add Dynamic Content Use to select outputs from previous steps Flowing data

30. Flowing data Trigger Outputs: File name Size File content Action 1 A binary field would see: File name Size File content Outputs: Title Count Action 2 A string field would see: A number field would only see: File name Size File content Count Title Size Count

31. Building flows from scratch

32. Building flows from scratch

33. Microsoft Flow Billing Understanding Flow Billing

34. Billing of Microsoft Flow Which Office 365 plans include Microsoft Flow? Office 365 Business Essentials Office 365 Business Premium Office 365 Education Office 365 Education Plus Office 365 Enterprise E1 * Office 365 Enterprise E3 * Office 365 Enterprise E5 https://us.flow.microsoft.com/en-us/pricing/ Flow Free 750 runs per month Unlimited flow creation 15-minute checks Flow Plan 1 4,500 runs per month Unlimited flow creation 3-minute checks Premium Connectors Flow Plan 2 15,000 runs per month Unlimited flow creation 1-minute checks Premium Connectors Org Policy Settings Business Process Flows

35. Billing of Microsoft Flow Free Trial 90 Days Community Plan does not have 90 limit Flow Runs Flow runs are pooled across all users (aggregated) It is not 750 runs per person Purchase additional Flow runs 50,000 Runs / USD $40.00

37. Monitoring Flow Runs

38. Quota Breakdown Runs Per License x Licenses 2000 x 7 = 14,000 pooled executions Where? Office 365 Admin Portal  Flow  Tenant  Quotas

39. Mitchell Pearson, mpearson@pragmaticworks /MitchellPearson1/ @MitchellSQL Mitchellpearson.com Introduction to Microsoft Flow