Washington, D.C.

Flow / Workflow Track

Sunday, December 12th 2021, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

WRK106 - Advanced Power Apps and Power Automate: Workarounds for Common Problems

Spend any amount of time in the Power Platform forums and you will begin to see a lot of similar questions asked over and over again. In this workshop we will look at some of the most common issues Citizen Developers encounter when trying to develop applications and workflows in the Power Platform. We'll examine each type of problem, analyze why they occur, and provide workarounds that you can use when you encounter them. The workshop will be divided into two parts. In the first we'll concentrate on Power Apps and in the second we'll look at Power Automate. Here is a general list of the overall topics we will cover: • Morning: Power Apps ○ Delegation ○ Working with Dates and Times ○ Conditional Formatting of data ○ Passing Data to and Retrieving Results from a Flow • Afternoon: Power Automate ○ Using Conditions and Switches effectively ○ Handling Loops and Parallel Branches ○ Working with Large Data Sources ○ Implementing Error Checking/Correction

Sunday, December 12th 2021, 9:00 am

  • William Huneycutt

    Microsoft MVP

WRK104 - Business Process Automation with Power Apps and Power Automate (Flow)

In 2016, Microsoft introduced two new tools in Office 365: Power Apps and Flow (now Power Automate). Power Apps is designed for power users everywhere to connect, create and share business apps and forms for your team. Power Automate is designed to create automated workflows between your favorite apps and services, such as SharePoint, to get notifications, synchronize files and collect data. As these products have evolved and matured since their release, Microsoft has made clear it is time for organizations to consider moving away from SharePoint Designer and InfoPath. This workshop is a deep dive into the capabilities of Power Apps and Power Automate as organizations transition from SharePoint Designer and InfoPath. In this workshop, users will learn how to get started quickly with Power Apps to create rich forms and apps complete with an Microsoft Office-like experience. • Users will learn how to create an app or form from scratch for use in the web or on mobile platforms. • Discover how to use built-in connections to connect Power Apps to cloud services such as Office 365 and OneDrive, and on-premises systems such as SharePoint. • Detailed comparison of Power Apps and InfoPath. This workshop will also discuss how to work smarter and more efficiently by automating workflows across the most common apps and services. • Users will learn how to build, manage, and administrator Flows in your environment. •  Learn to create Flows from scratch or by using pre-built templates in the visual designer. •  Discover how to connect Power Automate to over 100 data sources. •  Detailed comparison of SharePoint Designer workflows and Power Automate.. The future of SharePoint is exciting, and the addition of Power Apps and Power Automate can help to address the complex business processes faced by today’s business teams.

Sunday, December 12th 2021, 9:00 am

  • Scott Shearer

    Microsoft MVP, MCT
  • Wes Preston

    Microsoft MVP

WRK108 - Power Apps and Power Automate (Flow) for SharePoint Bootcamp

Power Apps and Power Automate are the successors to InfoPath and Designer Workflows for SharePoint. In this demo rich workshop, you'll spend the morning learning how to customize your SharePoint list forms with Power Apps and automate processes with Power Automate. You'll see how Power Apps can be used to make many of the customizations for which you may have used InfoPath in the past. We'll also cover how Power Automate can be used to do the same tasks for which you may be currently using Designer workflows - and much more..... Live demos will be used to illustrate the topics covered. In the afternoon, you'll have the opportunity to "take the wheel" and test out Power Apps and Power Automate for yourself. Through a series of hands-on labs, you'll gain first hand experience in customizing SharePoint list forms with Power Apps and automating business processes in SharePoint using Power Automate. Your instructors will be there to assist anytime you have questions or need some help. To participate in the hands-on portion of this workshop, attendees should bring a laptop computer. Attendees who bring tablets, even with keyboards, will likely experience difficulties in successfully completing the labs. Attend this session and say goodbye to InfoPath and SharePoint Designer workflows. Gain the skills you'll need to immediately start customizing your Office 365 SharePoint sites with Power Apps and Power Automate.

Monday, December 13th 2021, 9:00 am

  • Scott Shearer

    Microsoft MVP, MCT
  • William Huneycutt

    Microsoft MVP

WRK502 - Hands-On Power Automate (Flow) Workshop - Fundamental

Microsoft Power Automate is the successor to SharePoint Designer workflow and the future of process automation for SharePoint. While Flow is much more than a SharePoint-only tool, this session will focus on providing you with the skills to get started right away with SharePoint automation using Microsoft Power Automate. In this demo-rich workshop, you’ll learn by doing with hands-on labs. What we'll cover during the session: • Overview and how your organization can get started • Flow concepts (e.g. triggers, actions, conditions) and how they’re applicable • Flow design using templates and blank canvas • Flow creation for common SharePoint business requirements, e.g. document approval Demo environment is provided ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Monday, December 13th 2021, 1:30 pm

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT, Cloud Solution Architect at AIS

WRK604 - Getting Started with SharePoint 2013/2016/2019 Workflows

This half-day workshop will walk you through and get you up to the speed in developing SharePoint 2013 Workflows. We will also cover Power Automate. Developing SharePoint 2013 Workflows is a broad topic and between OOTB, SharePoint Designer, Visual Studio, Power Automate, Logic Apps and 3rd party products, the choices can be overwhelming. By the end of this workshop, you will gain the necessary knowledge to determine which method should be used for your next workflow. In this demo-driven workshop, we will cover the following topics in great detail: • The architecture of SharePoint 2013 Workflows • Important Features of SharePoint 2013 Workflows • Introduction to Workflow Manager • How to create custom workflows using Out of the Box Workflows? • How to customize out of the Box Workflows? • How to create SharePoint 2013 Designer Workflows? • How to create SharePoint 2013 Workflows using Visual Studio • How to create SharePoint 2013 Workflows as an App? • How to Debug SharePoint 2013 Workflows? • Getting Started with Power Automate • Getting Started with Logic Apps Pre-requisites: Familiar with SharePoint, SharePoint Designer You will learn: • Basics of SharePoint 2013 Workflows • Basics of Power Automate • Basics of Logic Apps • The architecture of SharePoint 2013 Workflows • Architecture Decisions for Building SharePoint 2013 Workflows • How to develop/test/debug SharePoint 2013 Designer and Visual Studio Workflows? The contents of this workshop are applicable to SharePoint Server 2013/2016/2019 and Subscription edition

Monday, December 13th 2021, 1:30 pm

  • Scott Shearer

    Microsoft MVP, MCT
  • William Huneycutt

    Microsoft MVP

WRK602 - Hands-On Power Automate (Flow) Workshop - Intermediate

In this Microsoft Power Automate workshop, you’ll learn by doing with hands-on labs. This session will provide you with the skills to get more proficient right away with SharePoint automation using Microsoft Power Automate. The workshop is geared towards participants who either have fundamental knowledge of Power Automate or have attended the SharePoint Fest morning/introductory workshop. What we'll cover during the session: • Power Automate (Flow) expressions • Advanced approval scenarios, e.g. escalation, parallel approval • OData filters for larger data sets in SharePoint • Workflow state machine using Power Automate • Must-know nuggets from real-world solutions Demo environment is provided ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Tuesday, December 14th 2021, 11:20 am

  • Scott Shearer

    Microsoft MVP, MCT

FLO102 - Expressions in Power Automate (Flow)

A deep knowledge of Flow expressions is critical to maximizing the power of Power Automate. In this demo rich session we'll take a deep dive into the types of expressions available and how to apply them. You'll see how to combine expressions, use expressions to format email text, how to use and apply date and string expressions, how to use expressions with collections and arrays and more... If you have a casual knowledge of Power Automate and want to "step up your game" with the use of expressions, attend this session!

Tuesday, December 14th 2021, 1:30 pm

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

FLO103 - Using Power Apps and Microsoft Power Automate (Flow) Together: Made for each other

Power Apps and Power Automate are both powerful tools for the citizen and professional developer. But using them together can take your application to a whole new level. In this talk we'll get you started with how to invoke a Flow from a Power App, how to pass information to the Flow, and how to return values back to Power Apps when the Flow completes. Along the way we'll discuss Best Practices that can make your Power Apps and Power Automate work more efficiently together. Even if you know both Power Apps and Power Automate, this session will help you get the most out of using them together.

Tuesday, December 14th 2021, 3:00 pm

  • Mike Fitzmaurice

    Chief Evangelist and VP for WEBCON - North America

FLO104 - Stage-Based Workflows: Principles and Practices

One feature that differentiates the Microsoft Power Automate (Flow) Premium plan is Business Process Flows; they're the Power Automate platform's implementation of stage/state machine logic. SharePoint Designer 2013 supports it, as do ISVs like WEBCON and Nintex. They allow workflows to move backwards, sideways, or any other way. They explain processes more easily. They're easier for users to participate in design. They're easier to modify. They're just, well, better. This session will start by explaining how stage-based designs and processes work, move on to why they're often far better than classic sequential processes, and conclude with examples of how to build and run such solutions. It's the most useful workflow "secret" you can possibly learn.

Tuesday, December 14th 2021, 4:20 pm

  • Terry Simpson

    Technical Evangelist

FLO105 - Art of the Possible: Automation Demystified

Every organization has processes in place, whether you are sitting in IT, finance, legal, sales, or any other functional areas. We also know processes sometimes can lead to hundreds of hours of paperwork, approvals, routing, printing, and mundane and repetitive tasks. But let’s face it….humans have better things to do and that’s why process automation is critical. However, different process requires a different set of capabilities as no process is the same. Join us in this technical deep dive to learn the various tools you may need to automate your process. Attendees will learn: • The various automation capabilities • How automation can save you time and increase productivity • Why it’s important to start automating your processes

Wednesday, December 15th 2021, 10:30 am

  • Sarah Haase

    Microsoft MVP

FLO201 - Your mobile lifeline: Leveraging Power Automate (Flow) buttons to drive productivity

It's time to work smarter. With the Microsoft Power Automate mobile app, you can build and execute push-button workflows that automate everyday tasks and transform your Digital Workplace experience. Need to quickly block your calendar for an impromptu meeting? Or send an automated email to your team letting them know you'll be working from home today? With Microsoft Power Automate buttons, you can start your workflows on-the-go with a single button click. This practical how-to session introduces button flows, showing how easy it is to create push-button flows for everyday Digital Workplace needs. You'll see examples of 4 easy-to-build flows and learn how the Microsoft Power Automate app can greatly improve your mobile workplace experience.

Wednesday, December 15th 2021, 1:20 pm

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

FLO202 - Building Modern Approvals: Using Microsoft Power Automate (Flow)

Approval workflows have always been one of the most important tools when building business processes in SharePoint. In this talk we will walk through everything you need to know to build modern approval workflows using Microsoft Power Automate. We'll start with the new built-in "Request sign-off" Flow and work out to an approval Flow with multiple sign-offs. Along the way I'll demonstrate how to retain an audit trail and troubleshoot your approval flow.

Wednesday, December 15th 2021, 2:40 pm

  • William Huneycutt

    Microsoft MVP

PWR203 - Business Process Automation with Power Apps and Power Automate (Flow)

In 2016, Microsoft introduced two new tools for Office 365: Power Apps and Flow (now Power Automate). Power Apps is designed for power users everywhere to connect, create and share business data with your team on any device in minutes. Power Automate (Flow) is designed to create automated workflows between your applications and services, such as SharePoint, to get notifications, synchronize files and collect data.  In this session, users will learn how to get started quickly with the Power Apps to create apps with an Microsoft Office-like experience. Users will discover how to use built-in connections to connect Power Apps to services such as SharePoint, Office 365, and OneDrive, and even on-premises systems such as SharePoint. Users will also learn how to share Power Apps with coworkers to take advantage of an app you created.  This session will also discuss how to get started with Power Automate. Users will learn how to take advantage of pre-built templates for creating workflows. Users will also learn how to create their own flows in an easy visual designer that works anywhere on the web. Finally, we'll discuss how to manage your Flows during and after runtime. The future of SharePoint is exciting, and the addition of Power Apps and Power Automate can help to address the myriad of business processes faced by today’s business teams.

Wednesday, December 15th 2021, 2:40 pm

  • Mike Fitzmaurice

    Chief Evangelist and VP for WEBCON - North America

FLO203 - Building Business Processes that Can & Will Evolve: Product-Neutral Principles

Far more than data management apps, workflow solutions need to factor in the need for frequent change. You should expect even the best-designed models and applications to be regularly modified -- and that's a good thing. This has an impact on how to design processes, how to create forms and reports, how to connect to external data, and how to maintain internal data. This session will talk about reasons why workflow solutions need to be modified so often, why you should embrace this, and strategies and tactics for addressing it. Its advice can be applied to Microsoft Power Automate (Flow), SharePoint Designer, WEBCON BPS, FireStart, Nintex, K2, or most anything else.

Wednesday, December 15th 2021, 4:20 pm

  • Scott Shearer

    Microsoft MVP, MCT

FLO204 - Real World Power Automate (Flow)

Looking for practical solutions to common issues encountered when writing Flows for SharePoint? Then this session is for you. Our time will be devoted to working through actual questions asked by and problems encountered by Microsoft Power Automate developers in the real world. We will explain the issues and look at each solution in detail.

Wednesday, December 15th 2021, 4:20 pm

  • Richard Toland

    Principal Architect/Developer at Perpetual Reality

FLO205 - SharePoint Designer 2013 Workflow for Cross-Site data and web services

Particularly useful to SharePoint on-prem users of versions 2013, 2016, and 2019; this session teaches how to leverage SharePoint Designer 2013 workflow to interface with web services. Here, we will examine use cases for list item creation and manipulation between site collections, as well as the constructs for integrating with non-SharePoint web services from either your on-prem or cloud platforms (such as Azure automation routines or Microsoft Power Automate). This methodology can be used to scale and seamlessly integrate between disparate SharePoint site/data on-prem, online and beyond.

Thursday, December 16th 2021, 9:00 am

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT, Cloud Solution Architect at AIS

FLO301 - Learn How to Write Futuristic Workflows in SharePoint 2013/2016/2019 On-Premises

Do you know even though Power Automate is the logical successor of SharePoint Designer Workflows currently there is no method available to automatically convert SharePoint Designer Workflows into Flow? Even though a lot of new feature sets are getting added to Power Automate, a lot of organizations still rely on SharePoint Designer and Visual Studio workflows to solve their current business needs. In this future-forward demo-driven talk, we will cover how we can write futuristic workflows using SharePoint Designer 2013 and Visual Studio so that when the time is right and you are ready to make a switch to another product/service (Power Automate or any other third-party product/service), you can reuse a lot of your earlier investment and have a smoother transition. The techniques covered in this talk will also help you during migration. The contents of this session are applicable for both SharePoint On-Prem (2013/2016/2019) as well as SharePoint Online. You will learn: • How to create futuristic SharePoint Workflows • Best practices for building SharePoint Workflows • How to transition SharePoint Workflows to Power Automate

Thursday, December 16th 2021, 10:40 am

  • Mike Fitzmaurice

    Chief Evangelist and VP for WEBCON - North America

FLO302 - When To Use What: Using The Automation Tool for The Right Task

Microsoft Power Automate (Flow) is a great fit for many automation problems. But there's more than one kind of Flow which can be built with Microsoft Power Automate. Some business problems that need transaction support. Others need to manage content Some involve data harvesting. Or systems administration. Or data synchronization. Different use cases need different types of tools. This session is all about making sure you use a hammer to pound nails and a screwdriver to twist bolts; we'll mention some third-party offerings in addition to Microsoft-delivered tech, but we won't play favorites.

Thursday, December 16th 2021, 1:00 pm

  • Scott Shearer

    Microsoft MVP, MCT

FLO303 - Take Your Power Automate (Flow) Skills to the Next Level!

This session will take your Power Automate skills to the next level. This demo intensive session will cover such topics as approval escalation, parallel branches, expressions, using variables and more. Flow is improving all the time and you'll see the latest enhancements. Finally, you'll see how to accomplish automation tasks that you now do in Designer workflows through Power Automate.