Chicago, IL

Monday, September 26th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

WRK103 - 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

Monday, September 26th 2022, 9:00 am

  • Scott Shearer

    Microsoft MVP and MCT
  • William Huneycutt

    Microsoft MVP

WRK105 - Hands-On Flow Workshop

Microsoft Flow 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 Flow. 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, expressions) and how they’re applicable • Flow design using templates and blank canvas • Flow creation for common SharePoint business requirements, e.g. document approval • How to administer Flow in your organization ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Monday, September 26th 2022, 9:00 am

  • Daniel Christian

    Microsoft MVP and MCT

WRK108 - Microsoft Power Platform In A Day Workshop

With the Power Platform having been available for over 6 years, it is now an enterprise level, low code platform to build reports, apps, flows and chatbots. For the first time ever you can build your own solution and make it available for your company users. This skill of building professional low code apps is in such high demand that makers have successfully made a career out of it. Join Daniel Christian, a Microsoft MVP, certified trainer and an early adopter of the Power Platform, as he walks you through how this Power Platform journey began and gives you a technical overview of Power Apps (Canvas and Model-Driven), Power Automate, Power BI and Power Virtual Agents. This workshop will comprise of several walk-through demos, stories with examples and even an interview with a surprise guest. Here is an overview of the workshop: · Power Apps ○ Canvas ○ Model-Driven ○ Portal · Power Automate ○ Flows ○ Robotic Process Automation · Power BI · Power Virtual Agents · Dataverse · Integration with Microsoft Teams · Cross platform integration · Soon to arrive features! So if you are someone who has heard about Power Platform and would like to get a better technical understanding on what the services have to offer, then you do not want to miss this workshop!

Tuesday, September 27th 2022, 9:00 am

  • Scott Shearer

    Microsoft MVP and MCT
  • Wes Preston

    Microsoft MVP

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

Wednesday, September 28th 2022, 9:50 am

  • Scott Shearer

    Microsoft MVP and MCT

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, September 28th 2022, 11:30 am

  • Amarender Peddamalku

    Digital Transformation Leader and Microsoft Modern Work Practice Lead at Perficient

FLO102 - Power Automate Multi-Stage Approval Workflows

In this session we’ll learn how to design and develop Multi-Stage Approval Workflows Using Power Automate. We will also learn how to restart the workflow from a given stage and how to include Dynamic Approvers. We'll dig into how to design and develop Automated escalations and Automated reminders. We will also learn how to log workflow history and ways to retain the history indefinitely.

Wednesday, September 28th 2022, 1:40 pm

  • Bobby Chang

    Power Platform Global Black Belt at Microsoft

FLO103 - Automate Your Way with RPA

This session will demystify the fuss around RPA (Robotic Process Automation), by showcasing how to automate against legacy web and client applications using Power Automate. We'll demonstrate how to leverage desktop flow with Power Automate Desktop, and how/when/why you would combine desktop automation with cloud flow and AI to provide end-to-end workflow solutions for your organization.

Wednesday, September 28th 2022, 3:30 pm

  • Mark Rackley

    Microsoft MVP

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

Wednesday, September 28th 2022, 3:30 pm

  • William Huneycutt

    Microsoft MVP

PLT104 - Business Process Automation with PowerApps and 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.

Thursday, September 29th 2022, 8:30 am

  • Bobby Chang

    Power Platform Global Black Belt at Microsoft

PLT201 - Power Platform Governance 101

Governance can be such a dreaded word but is key to foster safe and successful adoption for low-code/no-code tech. Power Platform has a slew of capabilities to secure, manage, monitor apps and workflows in your Microsoft 365 tenant. Join this session, as we focus on key Power Platform concepts to understand (e.g., environment types, connectors, Dataverse) and governance capabilities to administer Power Apps and Power Automate (e.g., Data Loss Policy, PowerShell, CoE Starter Kit).

Thursday, September 29th 2022, 10:20 am

  • Mark Rackley

    Microsoft MVP

FLO202 - 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, September 29th 2022, 2:00 pm

  • Scott Shearer

    Microsoft MVP and MCT

FLO203 - Power Automate Expressions

A deep knowledge of 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 extract data from 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 Flow and want to "step up your game" with the use of expressions, attend this session!

Thursday, September 29th 2022, 2:00 pm

  • Prashant G Bhoyar

    Microsoft MVP and MCT

DEV203 - Implementing Microsoft Teams Governance using Power Automate , Microsoft Graph & SharePoint

The adoption of Teams is skyrocketing, and we are seeing an increase in the Microsoft Teams sprawl. One of the methods to avoid Teams Sprawl is to use automated governance using Power Automate, Microsoft Graph APIs, and SharePoint. In this demo-driven session, we will cover how to implement Teams Governance using Power Automate ( Microsoft Flow ), Microsoft Graph APIs, and SharePoint. You will learn: 1) Microsoft Teams Governance via Automation 2) Automate Microsoft Team Provisioning using Power Automate ( Microsoft Flow ), Microsoft Graph APIs, and SharePoint 3) Automate Microsoft Team Provisioning using Logic Apps, Microsoft Graph APIs, and SharePoint

Thursday, September 29th 2022, 3:50 pm

  • Prashant G Bhoyar

    Microsoft MVP and MCT

DEV204 - Power Automate for Microsoft 365 Developers

Power Automate helps us to create intelligent automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and do much more. Power Automate ( Microsoft Flow ) has opened a Pandora box of features that developers can use to build real-life enterprise-grade solutions using the low code paradigm. For example calling the SharePoint REST APIs, calling Microsoft Graph APIs, calling External web services, and integrating with Azure services such as Azure Functions and Azure Dev Ops. In this demo-driven session, we will cover how developers can use some of the rich feature sets of Power Automate ( Microsoft Flow ) and build real-life enterprise-grade business applications. You will learn: • How to consume the REST Endpoints using Power Automate ( Microsoft Flow ) • How to consume Microsoft Graph APIs using Power Automate ( Microsoft Flow ) • How to call Azure Function from Power Automate ( Microsoft Flow ) • How to build enterprise-grade business applications in Microsoft 365 using Power Automate ( Microsoft Flow ) • How to convert Power Automate ( Microsoft Flow ) to Logic Apps

Friday, September 30th 2022, 10:20 am

  • Daniel Christian

    Microsoft MVP and MCT

APP302 - The Variety of Variables in Power Apps Canvas

Variables are one of the key features in an app to hold information that will be referenced later. Join Daniel Christian, Microsoft MVP and certified trainer, as he walks you through the variety of variables available in Power Apps canvas. This is a demo heavy session with real-world examples of how variables can improve the performance and efficiency of the apps.

Friday, September 30th 2022, 10:20 am

  • Scott Shearer

    Microsoft MVP and MCT

FLO302 - Adavnced Approvals in Power Automate

This session goes beyond basic approval concepts and explores a wide variety of approval scenarios including: • Using Power Automate Approvals with Teams • Parallel approval concepts • Creating approvals with a dynamic number of approvers • Running concurrent approval actions for a single request And more... If you a basic understanding of how to use Power Automate approvals and want to "step up your game", this session is for you!

Friday, September 30th 2022, 10:20 am

  • Daniel Glenn

    Microsoft MVP

PLT302 - Work With Your On-Premises Data From Anywhere

Microsoft Power BI, Power Automate, 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. The hybrid office is even more efficient when you can work with your date from anywhere! 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 for your employees working from anywhere. You will walk-away from this session with the knowledge you need to immediately start using your on-premises data with Microsoft 365.

Friday, September 30th 2022, 12:30 pm

  • Eric Overfield

    Microsoft MVP, RD and MCT

FLO303 - 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

Friday, September 30th 2022, 1:50 pm

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

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