Seattle, Washington

Power Automate (Flow) / Workflow Track

Monday, May 9th 2022, 9:00 am

  • Scott Shearer

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

    Microsoft MVP

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.

Monday, May 9th 2022, 9:00 am

  • William Huneycutt

    Microsoft MVP

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

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT

WRK110 - Hands-On: Azure For Power Platform Developers Masterclass

In this hands-on workshop, we will cover how to use Azure for custom development in Microsoft Platform, Power Automate, Power Apps, Power Virtual Agents, Dataverse, and Power BI. We will cover: • Microsoft Azure Key Concepts • How does Power Platform use Azure? • How can fusion teams take advantage of Microsoft Azure and Microsoft Power Platform? • Authentication and Authorization in Azure • Azure + Power Automate • Azure + Power Apps • Azure + Power Virtual Agents • Azure + Power BI • Azure + Dataverse • What are Azure Functions? • What are Logic Apps? • What is Azure Bot Service? • How to create an enterprise-grade app using Azure and Microsoft Power Platform? At the end of the workshop, attendees will have a working knowledge of Azure and how to use it to implement the customizations in the Microsoft Power Platform. Access to Azure, Microsoft Power Platform ( Power Apps, Power Automate, Power Virtual Agents, and Power BI ) will be provided to create the customization. The target audience of this hands-on workshop is Developers, Power Users, and IT Pros who want to get into development.

Tuesday, May 10th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

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 Microsoft 365 Evangelist and Microsoft MVP
  • William Huneycutt

    Microsoft MVP

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, MCT

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 Microsoft 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, 1:40 pm

  • Eric Overfield

    Microsoft MVP, RD

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

    Microsoft MVP

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, 8:30 am

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

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, 10:20 am

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT

SPT202 - Zero to Hero in Microsoft Dataverse (Common Data Service) in 70 minutes

Microsoft Dataverse is a low code data platform that provides relational data storage, rich data types, and enterprise-grade governance. It allows us to securely store and manage data used by business applications. Common Data Service ( CDS) has been renamed to Microsoft Dataverse. In this demo-driven session, we will cover the following topics in great detail: • What is Microsoft Dataverse (Common Data Service)? • How Power Platform uses Microsoft Dataverse? • What are Tables/Entities? • How to implement role-based security? • How to use Microsoft Dataverse to create enterprise-grade apps? • Microsoft Dataverse Best Practices

Thursday, May 12th 2022, 12:10 pm

  • Shawn Gray

    null

SOL03 - Manage and Automate Your Process: Clicks not Codes

How well do you know your processes in your company? How do you update them? Do you want more time back in your day to focus on more important tasks? At Nintex, we believe in process management and automation. With Nintex Promapp, we can help you map, define, and collaborate on processes across your entire organization. With a click of a button, you can generate a workflow for automation. Even better is when you can scale this solution to everyone in your organization because we embrace and empower citizen developers. Attendees will learn: • Why process management is important for your organization • How to effectively collaborate across organization through process management • Automate your processes with a click of a button • Configuring your workflow for automation

Thursday, May 12th 2022, 2:00 pm

  • Scott Shearer

    SharePoint, Flow and Microsoft 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:50 pm

  • Sameer Mohammed

    Microsoft Practice Lead

FLO204 - RPA to automate real word invoice processing using Power Automate

Do you know Robotic Process Automation is the most popular technology in the business world today? Automated invoice processing using RPA helps in decreasing processing time substantially from months to hours, lets your data entry staff focus on higher value-added tasks, manages invoices better, and improves supplier relationships. In this session, Sameer Mohammed will demonstrate a real-world example of vendor invoice processing using RPA with Power Automate. These invoices can be quite complex and as lengthy as 8 to 10 pages with some repetitive sections like invoice details with several line items. Also, in this session, you will see complex validations, process approvals over Microsoft Teams, and emails for notification. Sameer will demonstrate the whole process which might take days to write but Sameer will not be writing real code. Attend this session to learn how to truly automate processes at your organization. Who is this session for? This session is for both decision-makers and technical guys. https://aqltech.com/robotic-process-automation-consulting-services-ad/

Friday, May 13th 2022, 9:00 am

  • Scott Shearer

    SharePoint, Flow and Microsoft 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, 9:00 am

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT

ADM301 - Manage Power Platform Like a Pro using PowerShell

The Power Platform Admin center offers a comprehensive list of features to manage the Power Platform. However, the admin center is not great at performing bulk operations and implementing automation as part of your governance process. In this demo-driven session, we will cover how to manage the Power Platform using PowerShell, perform bulk operations, and implement automation as part of your Power Platform governance processes. You will learn: • How to use PowerShell for Power Apps and Power Automate (Microsoft Flow) • Managing Tenant Level Settings • Creating and Managing environments • Managing Power Apps and Power Automate (Microsoft Flow) Owners • Managing Power Apps and Power Automate (Microsoft Flow) Connections • Managing Canvas Apps • Pulling Usage Statistics • How to implement automation as part of your Power Platform Governance Policies • Best Practices

Friday, May 13th 2022, 10:20 am

  • Daniel Christian

    Microsoft Business Application MVP

PWR302 - Power Platform Integration - Power Apps, Automate, Power BI & Virtual Agents

This session will show how Power Platform services Power Apps, Power BI, Power Automate & Power Virtual Agents can collaborate with each other, connect to data sources like Dataverse, SharePoint, SQL, etc. and create integration experiences to solve business problems.

Friday, May 13th 2022, 12:30 pm

  • Mark Rackley

    Microsoft MVP

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, 12:30 pm

  • Mike Fitzmaurice

    VP - North America, WEBCON

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

Friday, May 13th 2022, 1:50 pm

  • Daniel Glenn

    Microsoft MVP

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.