Seattle, Washington

Power Automate (Flow) / Workflow Track

Monday, May 9th 2022, 9:00 am

  • William Huneycutt

    ASPE Training | Upskill Tech

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

Learn how to get started quickly with Power Apps and Power Automate (Flow) in SharePoint Online. Discover how to use built-in connections to connect Power Apps to services such as SharePoint Online, Office 365 apps, and even SharePoint on-premise. Learn how to customize the look and feel of forms and apps to meet the needs of users and apply company branding. Also, learn how to share Power Apps with colleagues without going over budget.  • Customize SharePoint list forms with Power Apps • Create a canvas app based on a SharePoint list • Connect to data sources • Themes, branding, and layouts • Conditional formatting • Rules and data validation • Formula bar This session will also discuss how to get started with Power Automate (Flow). Learn how to take advantage of pre-built templates for creating workflows. Learn how to create custom Flows in an easy-to-use visual designer right in a web browser. Finally, we'll discuss how to manage your Flows during and after runtime. • Connectors, data sources, and gateways • Events vs triggers • SharePoint Designer actions vs Flow actions • Conditions for Flow • Workflow history • Flow connections and ownership • Licensing The future of SharePoint is exciting, and the addition of Power Apps and Power Automate (Flow) can help to address the challenges faced by today’s information workers.

Monday, May 9th 2022, 9:00 am

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP
  • Wes Preston

    Independent consultant working with platform alignment and no-code solutions with SharePoint and/or PowerApps

WRK107 - 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.

Tuesday, May 10th 2022, 9:00 am

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner

WRK405 - 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 very 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: Part One: Power Apps • Managing Delegation Warnings • Working with Dates and Times • Conditional Formatting of data • Passing Data to and Retrieving Results from a Flow Part Two: Power Automate • Using Loops and Parallel Branches • Working with Large Data Sources • Using Conditions and Switches effectively • Implementing Error Checking/Correction

Tuesday, May 10th 2022, 9:00 am

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP
  • William Huneycutt

    ASPE Training | Upskill Tech

WRK406 - Hands-On Flow Workshop

In this Microsoft Power Automate workshop, you’ll learn by doing with a combination of lecture and hands-on labs. This workshop will provide you with the skills you need to start automating your business processes using Power Automate. In our morning session, we'll introduce you to Power Automate. Topics that we'll cover include: • 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 In the afternoon, we'll take your Flow skills to the next level. Afternoon topics will include: • 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 A Demo environment is provided ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Tuesday, May 10th 2022, 1:30 pm

  • Nick Brattoli

    Microsoft MVP, Collab365 Community Manager, and Independent Consultant

WRK604 - Building an employee recognition solution with SP, Power Apps, Power Automate & Power BI

An employee recognition app is a quick-and-easy way to create content and engagement for your SharePoint or Teams-first intranet. In this half-day workshop, join Nick Brattoli as you build an employee recognition application from scratch together using Power Apps, Power Automate, and even Power BI! You'll work through topics such as: • Planning and structuring your data • Creating an entry form • Displaying recognition awards • Adding approvals, notifications, and even printable certificates! • Using Power BI to add visual flair and statistics If you’re looking for a cool solution to build to drive user adoption or get buy-in from leadership, you don’t want to miss this!

Wednesday, May 11th 2022, 9:50 am

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

FLO101 - Power Automate for the Absolute Beginner

If you have been wanting to get started creating Flows with Power Automate, this is your chance! In this session, you'll learn: • What can be done with Flows • How are Flows different than SharePoint Designer Workflows • How to create Flows for everyday tasks such as sending automatic reminder emails • How to create Flows from templates • The best resources for advancing your Flow skills • Where to get help And more... Attend this demo-rich session and start creating Flows with Power Automate today!

Wednesday, May 11th 2022, 11:30 am

  • Mike Fitzmaurice

    VP - North America, WEBCON

FLO102 - When To Use What: One Tool Does Not Fit All Use Cases

Microsoft Flow is a great fit for many automation problems. But there's more than one kind of Flow. 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.

Wednesday, May 11th 2022, 1:40 pm

  • Eric Overfield

    PixelMill, RD, MVP

FLO103 - Power Automate Vs Azure Logic Apps | Choosing the Right Workflow Engine for You

Power Automate and Azure Logic Apps help users build automated processes and workflows with no-code or low code, intuitive interfaces. Are you confused by the difference between these two? You’re not alone! Azure Logic Apps and Power Automate are impressive tools in their own right and while there is quite a bit of cross over between the two (Power Automate is a shell over Logic Apps), it can be challenging to determine which tool to use. Join Eric as he walks you through the difference between Power Automate and Logic Apps. During this session, he breaks down how you can determine which tool is right for your specific use case. In this session: • Learn the difference between Logic Apps and Power Automate • Discover the 5 essential guidelines to evaluate when determining which to use • See live examples/demos of two solutions using Logic Apps and Power Automate

Wednesday, May 11th 2022, 3:30 pm

  • Mark Rackley

    CSO at PAIT Group and SharePoint Hillbilly

FLO104 - How to Execute JavaScript, TypeScript, and Excel Formulas In Power Automate

Power Automate has become an essential tool for the Microsoft 365 developer. However, all too often executing simple logic can become tedious and painful using Power Automate standard features. Doing math in Power Automate shouldn't be so painful! Thankfully, Power Automate developers can now create scripts that use JavaScript, TypeScript, or even Excel formulas to execute complicated business logic and bring more power to your Power Automate solutions. Attend this demo-packed session to learn out to take your Power Automate Flows to the next level as we dive into a real-world scenario and build a practical solution step-by-step.

Thursday, May 12th 2022, 9:00 am

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner

FLO201 - Power Automate Desktop: How to Automate Almost Anything

Power Automate flows can do a lot to automate repetitive tasks. But up until now they only worked if there was a pre-built connector with actions that can accomplish the task or at least an existing Application Programming Interface API that you could use to build a custom connector. In this talk we'll look at Power Automate's entry into the world of Robotic Process Automation (RPA) called UI flows. Using UI flows You can automate repetitive tasks on your desktop in Windows or a Web application. UI flows record and play back user interface actions, like keyboard entries, mouse clicks, etc. UI flows open up possibilities to automate applications that don't have a pre-built connector or an API.

Thursday, May 12th 2022, 1:30 pm

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

FLO203 - Expressions in Power Automate

A deep knowledge of Power Automate expressions is critical to maximizing the power of your Flows. 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!

Thursday, May 12th 2022, 3:30 pm

  • Mike Fitzmaurice

    VP - North America, WEBCON

FLO204 - 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.

Friday, May 13th 2022, 9:00 am

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

FLO301 - 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.

Friday, May 13th 2022, 12:30 pm

  • Mark Rackley

    CSO at PAIT Group and SharePoint Hillbilly

FLO303 - Working with JSON and Arrays in Power Automate

Creating flows in Power Automate is one of the most powerful features available to the citizen developer. However, in order to truly master creating flows citizen developers need to understand how to parse the often confusing arrays and JSON objects that are returned from various processes. In this session, Mark Rackley will break down how to effectively: • Access data in an array • Parse a JSON object • Generate a sample schema Don’t miss your chance to unlock a world of powerful features in Power Automate by learning to master data in Power Automate.

Friday, May 13th 2022, 1:50 pm

  • Daniel Glenn

    Senior Director of Hybrid Office and U.S. Delivery at Creospark

CM304 - Use Your On-premises Data with Power Apps, Power BI, and Power Automate (Flow)

Microsoft Power BI, Power Automate (Flow) and Power Apps are powerful cloud tools that can take your on-premises data, stored in systems like SQL and SharePoint, to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy. In this session, we will discuss the benefits of using the cloud tools and how workflow, analytics, and business apps can utilize your on-premises data. We will setup a data gateway, connect to on-premises data sources, and discuss how to use that data in Microsoft 365 to create rich business solutions. You will walk-away from this session with the knowledge you need to immediately start using your on-premises data with Microsoft 365.

Friday, May 13th 2022, 1:50 pm

  • Mike Fitzmaurice

    VP - North America, WEBCON

FLO304 - Stage-Based Workflows: Principles and Practices

One feature that well-justifies Microsoft Flow Plan 2 is Business Process Flows; they're the Flow platform's implementation of stage/state machine logic. SharePoint Designer 2013 supports it, as do offerings by ISVs like WebCon and Nintex. 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.