Chicago, Illinois

Power Platform 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, PowerBI.com, 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.

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!