Seattle, Washington

PWR Tuesday Workshops

Tuesday, May 10th 2022, 9:00 am

  • Daniel Christian

    Microsoft Business Application MVP

WRK503 - Power Apps: App design patterns

This is a beginner to intermediate level class meant for makers who have built a few apps using the out-of-box forms and are now interested in improving the UI and UX design patterns to make the app more user-friendly and reduce end-user mistakes. We'll build an elegant canvas app to submit, edit and delete data. Our primary focus will be on the design features such as: • Building a smart navigation menu. • Improve the look and feel of galleries and forms. • Pop-up messages • Responsive design

Tuesday, May 10th 2022, 9:00 am

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Microsoft MVP

WRK404 - Everything you wanted to know about Power BI (but were afraid to ask!)

Power BI is the gold standard for cloud based report delivery. It’s very approachable – you can get up and running with it in minutes, at the same time, it’s very robust, secure and extensible. As you might expect, it has many pieces and nuances, and it’s important to understand what is possible, even if you may not take immediate advantage of some features, in order to understand what to use when. Join John White (MVP) and Jason Himmelstein (MVP) for this all-day tutorial which will help to guide you through building a complete analytical solution, using all the features of Power BI. We will start from nothing, and create queries that import and integrate data from many different sources. You will also learn how to refresh data using the on-premises data gateway and the personal gateway to connect to existing on-premises data from a variety of sources. In addition, you will see an overview of the many other additional features available in Power BI. At the end of this seminar you will be ready to not only start using Power BI for your projects, but you will also understand which approach is best for different situations. Bring your questions, and we’ll do our best to answer them.

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, 9:00 am

  • Max Fritz

    Microsoft Program Manager

WRK504 - Build your first Microsoft Teams App with Power Platform

Have you ever thought of a great idea for an app but you're just not a developer? Maybe you have a paper-based process that slows down your work today? Wish your team or department could work more collaboratively? If you found yourself thinking yes, then you don't want to miss this workshop! In this workshop we will walk you through step by step creating your very own app in Microsoft Teams using free technologies such as Dataverse for Teams, Power Automate, and Power Virtual Agents. All you need to bring is yourself, your curiosity, and your computer, and you'll have a fully functioning app by the end of the workshop!

Tuesday, May 10th 2022, 9:00 am

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT

WRK407 - Building Intelligent Enterprise-Grade Virtual Agents (Bots) using MS Power Platform & Azure

Microsoft's CEO Satya Nadella has said: "Human Language is the new UI layer, bots are like new application". As more and more bots are getting popular in homes and enterprises, the demand for custom bots is increasing at a rapid pace. The Microsoft Bot Framework is a comprehensive offering that we can use to build and deploy high-quality bots for our users to enjoy wherever they are talking. Power Virtual Agents a SaaS offering from Microsoft empowers teams to easily create powerful bots using a guided, no-code graphical interface without the need for data scientists or developers. Microsoft Cognitive Services let you build apps with powerful algorithms to see, hear, speak, understand and interpret our needs using natural methods of communication, with just a few lines of code. Easily add intelligent features – such as emotion and sentiment detection, vision and speech recognition, language understanding, knowledge, and search – into your app, across devices and platforms such as iOS, Android, and Windows, keep improving, and are easy to set up. In this hands-on workshop, we will cover how to build the no-code intelligent help desk bots using Power Virtual Agents, Microsoft Bot Framework, and Cognitive Services. The help desk bot will be able to answer questions related to employee benefits, open healthcare enrollment, etc. Access to SharePoint online site, Microsoft Team, and Azure will be provided to create the Bots. The target audience of this hands-on workshop is Power Users, IT Pros, and Developers. The contents of this workshop are applicable to SharePoint Online as well as SharePoint On-Prem as well. You will learn: • What are Power Virtual Agents? • What is Microsoft Bot Framework? • What is Microsoft Bot Framework Composer? • What is Azure Bot Service? • How to create bots using Microsoft Bot Framework? • What are Cognitive Services? • How to leverage Bot Framework and Cognitive Services to implement enterprise-grade bots? Please note: Attendees will need to bring their own laptop with internet access and modern browsers like Microsoft Edge, Google Chrome, Firefox, Safari. The tablets will not work.

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!