Seattle, Washington

PWR Monday Workshops

Monday, May 9th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

WRK106 - Dataverse for Teams: Extending Teams with Apps, Flows, and Bots

Use of Microsoft Teams has exploded for many companies during the global pandemic. For many organizations Teams has become the app that connects all their employees together. Power Platform apps, like Power Apps, Power Automate, and Power Virtual Agents, provides a low-code platform for extending that functionality. In September, 2020 Microsoft announced Dataverse for Teams. Dataverse for Teams is included in the Teams license so you can build apps, flows, and bots that make use of relational data storage, rich data types, and enterprise-grade governance without additional expense. In this workshop we'll look at how to use Dataverse in the Power Platform to extend the Teams application. By the time you leave you'll have an integrated Teams application and bot that can help your employees manage their presence as people move back into the office after the Pandemic. We'll cover the following with slides and hands-on exercises. • What does the Teams License cover? • Differences between Dataverse (CDS) and Dataverse for Teams • Creating Dataverse Relational Tables • Securing Dataverse for Teams Tables • Building a Power App with Dataverse for Teams • Integrating Dataverse for Teams with a Flow • Accessing Dataverse for Teams from a Bot • Managing Dataverse for Teams Environments • Deploying Custom Apps, Bots, and Flows to additional Teams

Monday, May 9th 2022, 9:00 am

  • Treb Gatte

    Microsoft MVP, MBA

WRK103 - Power BI Bootcamp for SharePoint Professionals

NOTE: YOU WILL NEED A COMPUTER WITH THE LATEST VERSION OF POWER BI DESKTOP INSTALLED PRIOR TO WORKSHOP TIME. THIS IS A HANDS ON BOOTCAMP. Need to create stunning dashboards from your SharePoint data? Yes you do! In this bootcamp, we’ll show you: • How should I approach my BI need? • What things should be considered when creating dashboards? • What are the best practices? • How much is this going to cost me to license? • What security aspects should concern me? Who should take this course: If your company uses Office 365 or SharePoint 2013/2016 and you are a: • Manager • Business Analyst • Power User • SharePoint Administrator • Consultant If you work in these areas, you will see value: • Marketing • Information Technology • Finance • Sales • Social Media The class assumes no prior knowledge of Power BI and Data Concepts. What is required for this class: Install Microsoft Power BI Desktop on your laptop (recommended but not required) We'll provide an Office 365 site for you to use for exercises In this workshop you will: • Learn how to create Production Dashboards using Power BI, from SharePoint list and document library data • How to use Power BI in a multitude of situations, including ad hoc analysis and the creation of formal dashboard. • Learn the Power BI components: Power BI Desktop,, Power BI mobile applications and how they can be used with Office 365 and SharePoint • Receive an introduction into the core functions of Power BI; Data extraction, loading and transformation using Power Query Formula Language (“M”) and DAX. • Receive some guidelines on how to extract Project data in fast manner. • Discover some data modeling practices that will ensure you have maximum flexibility in analysis. You'll also learn some visualization best practices to ensure you can tell your digital story effectively • Learn best practices for maintaining content with your organization This workshop provides an end to end view of Power BI for SharePoint reporting, so that you are able to use Power BI immediately for your needs.

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.