Seattle, Washington

Power Platform Sessions & Workshops

Sessions

Wednesday, May 11th 2022, 9:50 am

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT

PVA101 - Zero to Hero in Power Virtual Agents in 70 Minutes

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. 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. In this demo-driven session, we will cover the basics of the Power Virtual Agents. We will cover how to get started with the Power Virtual Agents and build a working enterprise-grade bot for your organization. You will learn: • What are Power Virtual Agents? • Bots in Microsoft Ecosystem • What is Azure Bot Service? • How to call Power Automate (Microsoft Flow) from Power Virtual Agents? • How to create bots using Power Virtual Agents?

Wednesday, May 11th 2022, 9:50 am

  • Wes Preston

    Microsoft MVP

APP101 - Intro to Power Apps for Microsoft Teams, Lists, and SharePoint Users

If you create business solutions with SharePoint lists and Microsoft Lists If you surface information and solutions via Microsoft Teams If you're concerned with the potential complexity of Power Apps This session will show why Power Apps should be considered part of your toolset. We will cover: • Simple extensions of the SharePoint and Microsoft Lists experience with Power Apps • How to take data from lists to Teams and mobile experiences • Power Apps examples that bring immediate value and set a foundation for further enhancements

Wednesday, May 11th 2022, 9:50 am

  • Liz Sundet

    Microsoft Program Manager

BI101 - Getting started learning Power BI

There are some awesome things that can be done with Power BI, from analyzing data to doing some really cool visualizations and dashboards. However, knowing where to start can be a daunting process. This session will cover how to get started; for instance knowing relational database structures, process for creating reports and knowing where to go for resources on training and questions. After this session you will know the basics of Power BI and getting started on your journey.

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

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Microsoft MVP

BI102 - Your guide to understanding Power BI

Struggling to understand what Power BI choices are the right ones to make? Confused by the licensing so much that trying to make heads or tails of how to get your project started is a step too far to think of taking? Join us for this introduction to the wonderful world of Power BI. We will begin with understanding the real world decisions around licensing, discuss & demo the options for doing reporting, and finish with dashboards & sharing. If you are beginning your journey into the Power BI world, this is the session for you. We will set you up for success throughout the rest of the conference and help you look to drive your business using data.

Wednesday, May 11th 2022, 1:40 pm

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

APP103 - Microsoft Power Apps: Building Responsive Design Apps for Every Device

Power Apps is a great no-code tool lets "citizen developers" create applications that are designed to run on Desktop PCs, Web Browsers, Tablets, and Mobile devices. But if you want to avoid building 3 or 4 different versions of your App you need to know how to design your Power App to adjust for different sizes, resolutions, rotation, and types of layouts. In this session we'll review all the Tips and Tricks you need to know to easily build one Power App that will adjust to work on any device that supports Power Apps and look good in the process.

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

  • Vlad Catrinescu

    Microsoft MVP | MCT Regional Lead

PVA103 - Creating Power Virtual Agent Chatbots for Microsoft Teams

Power Virtual Agents empowers users to easily create powerful bots using a guided, no-code graphical interface without the need for data scientists or developers, and you can even deploy them in Microsoft Teams! In this session, Creating Power Virtual Agent chatbots for Microsoft Teams, you’ll learn to create Power Virtual Agent chatbots for Microsoft Teams. First, you’ll explore the basics of Microsoft Power Virtual Agents. Next, you’ll discover how to create a chatbot using the Power Virtual Agents Teams app. Finally, you’ll learn how to publish your bot in Microsoft Teams.

Wednesday, May 11th 2022, 3:30 pm

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Microsoft MVP

CM104 - 6 Ways to Get Insights on your Microsoft 365 Document usage

What happened to the document? How did that get here? Is anybody reading this stuff? You've gotten these questions - how hard was it to answer them? The information is all available, but the best route to the insight is not always obvious. In reality there are multiple ways to report on your usage, each with different strengths and weaknesses. This demo-rich session will highlight 6 different approached to retrieving and reporting on Microsoft 365 usage information.

Wednesday, May 11th 2022, 3:30 pm

  • Treb Gatte

    Microsoft MVP, MBA

BI104 - SharePoint, Teams and Power BI Integration Strategies

This session will highlight the rich functionality that you can bring to your business needs with the integration that is available between Power BI and Office 365 functionality. We'll discuss why you may want to integrate functionality and how to license for it. Demos will be: • Integrating Yammer, Forms, and Word into Power BI • Integrating Power BI into Office 365 Communications site, Sway, and into a Teams channel.

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

  • Treb Gatte

    Microsoft MVP, MBA

BI201 - Unlocking SharePoint's Content Services Data with Power BI

In today's world, the ability to convert unstructured data from files like document scans and photos into actionable, structured data is key to unlocking a lot of organizational data. Office 365 Content Services provides some functionality that does this for you automatically. Most are not aware of this service's functionality nor it's long term importance. In this session, we'll take you through what SharePoint Content Services has to offer from a functionality and data perspective, what use cases are supported by this data, and how to mine the data using Power BI and Flow.

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

  • Wes Preston

    Microsoft MVP

APP202 - Power Apps: A New Approach to List Data for the SharePoint User

Power Apps is an excellent tool for custom forms and facilitating business processes (along with Microsoft Flow). Did you know Power Apps is also capable of building better list views? See how Power Apps can be used to display richer and more functional views of your data in Teams, SharePoint, or on mobile views.

Thursday, May 12th 2022, 10:20 am

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Microsoft MVP

BI202 - Power BI Premium – When Do I Need It?

Power BI Dedicated Capacity (Premium) is a way to get past many limitations of the shared Power BI service. However, with great power comes great responsibility. This session will outline exactly what Power BI Premium is, what features it unlocks and what limitations it changes. We will also call out situations where Premium may not be appropriate, and the steps that you need to take to ensure that you get the maximum value from it. If you’re considering a move to Power BI Premium, you’ll want to attend this session.

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

  • Charles Lamanna

    Microsoft Corporate Vice President, Business Applications & Platform
  • James Olenik

    Microsoft, Director of Product Management, Dataverse
  • Julie Strauss

    Microsoft, General Manager, Power Platform Pro Developer & Admin Experiences
  • Ryan Cunningham

    Microsoft, Vice President, Microsoft Power Apps
  • Stephen Siciliano

    Microsoft, General Manager for Power Automate

KEY200 - Empowering Everyone with Microsoft Power Platform and Dynamics 365 & Power Platform AMA

The key to future success is empowering everyone—the heart of Microsoft Power Platform and Dynamics 365. To drive this future, Microsoft is expanding on its stack of low code solutions. Join Microsoft Business Applications and Platform CVP Charles Lamanna as he shares the vision for Power Platform and Dynamics 365 and the product roadmap. Discover how the low code revolution is changing global business, empowering everyone to develop business solutions across the digital landscape. Then join the Power Platform team for a Power Platform Ask Me Anything.

Thursday, May 12th 2022, 2:00 pm

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT

APP203 - Building Model Driven Apps in Power Apps

Model-driven app design focuses on adding components such as forms, views, charts, and dashboards to tables using an app designer tool. Model-driven apps are especially well suited to process-driven apps that are data-dense and make it easy for users to move between related records. In this demo-drive session, we will cover the following topics in detail. • What are Model-Drive Apps? • How to get started with them? • How to build enterprise-grade Model-Driven apps? • Key differences between Model-Driven Apps and Canvas Apps in Power Apps • Application lifecycle management of Model-Driven Apps • Model-Driven Apps best practices

Thursday, May 12th 2022, 2:00 pm

  • Daniel Glenn

    Microsoft MVP

BI203 - Power BI Sharing - Your Options for Keeping Everyone Informed

Every organization is a data organization and you must collaborate on data to stay on track. Sharing insights from within Power BI will give you an advantage and help steer your organization in the right direction. However there are some pitfalls with sharing - if you don’t know your options and set proper governance, you could be on your way to a data breach or giving your private information to the competition. In this session, you will get a short introduction to Power BI and understand where data resides, why and how you should share with your colleagues and outside partners, and get a strategy for setting governance for your data. You will walk away with the outline of a governance plan, an understanding of your sharing options, and the sharing settings you should immediately turn off.

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

  • Daniel Christian

    Microsoft Business Application MVP

APP204 - Working with Large Data Sets in Power Apps

This session demonstrates how Power Apps can use large data sets and still be fully functional. Join Daniel Christian, a Microsoft MVP, certified training and an early adopter of Power Platform, as he demonstrates how data sources such as Dataverse, SharePoint & SQL with over 40,000 items or rows can be fully functional in a Power App as long as you use follow the rules to avoid any delegation issues.

Thursday, May 12th 2022, 3:50 pm

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Microsoft MVP

BI204 - 5 Reasons you want Paginated Reports in your life

You're already familiar with Power BI and the Power BI Desktop PBIX files. These tools are great for analytical reporting, but when it comes to things like printing, and subscriptions, well, it falls a little short. That's where Paginated reports come in. Paginated reports draw upon the decades of experience in operational reporting from SQL Server Reporting Services, but they work in the Power BI service, enabling many new scenarios and opportunities. This demo-rich session will explain what paginated reports are all about, and demonstrate 5 reasons that you'll want to start using paginated reports immediately.

Thursday, May 12th 2022, 3:50 pm

  • Ben Vanderberg

    Principal Platform Evangelist - Adobe

APP205 - Add documents and e-signatures to your Power Apps

Creating PDFs and other documents do not have to be a chore. In this session, we will learn: • How to generate documents from a Canvas-based Power App using Adobe PDF Services • Add conditional logic, tables, lists, and images dynamically within a Power App using Adobe PDF Services with Power Automate • Capture legally compliant e-signatures within a Power App using Adobe Sign This session is ideal for beginner to intermediate Power Apps users who are interested in bringing document experiences into their apps.

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

  • Sarah Haase

    Microsoft MVP | Office 365 enthusiast | User adoption advocate

PWR301 - Your mobile lifeline: Leveraging Power Automate buttons to drive productivity

It's time to work smarter. With the Power Automate mobile app, you can build and execute push-button workflows that automate everyday tasks and transform your Digital Workplace experience. Need to quickly block your calendar for an impromptu meeting? Or send an automated email to your team letting them know you'll be working from home today? With flow buttons, you can start your workflows on-the-go with a single button click. This practical how-to session introduces button flows, showing how easy it is to create push-button flows for everyday Digital Workplace needs. You'll see examples of 4 easy-to-build flows and learn how the Power Automate app can greatly improve your mobile workplace experience.

Friday, May 13th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

TMS301 - Intro to Dataverse for Teams: Extending Microsoft Teams with Apps and Flows

Use of Microsoft Teams has exploded for many companies as a result of 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. But extending Teams with new apps, flows, and bots requires a place to store content. SharePoint is a possibility, but from a data point of view SharePoint has a lot of limitations since it isn't an actual relational database. Dataverse, formerly known as CDS, provides relational data storage, rich data types, and enterprise-grade governance. But Dataverse has always been a premium feature requiring extra licensing. This is where Microsoft Dataverse for Teams comes in. Using the Power Apps application inside Teams we can build and deploy apps using a custom version of Dataverse that is included in the Microsoft Teams license. This provides access to a real relational database and one-click solution deployment to the Teams app. In this talk we'll take a look at what Dataverse for Teams and how it can be used in the Power Platform to extend the Teams application. We'll cover the following points with slides and demos. • What does the Teams License cover? • Differences between Dataverse (CDS) and Dataverse for Teams • Creating Dataverse Relational Tables • Building a Power App with Dataverse for Teams • Integrating Dataverse for Teams with a Flow • Accessing Dataverse for Teams from a Bot

Friday, May 13th 2022, 9:00 am

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP

BI301 - Deep Dive on Power BI and SharePoint

This demo rich session will explore many of the nuances involved with using a combination of Power BI and SharePoint. SharePoint data can be finicky to retrieve, and this session will show examples and suggest a few best practices for doing so. In addition, connecting Power BI to SharePoint opens up a whole new world for Excel. If it can be done with Power BI and SharePoint, this session will show you how.

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

  • Wes Preston

    Microsoft MVP

APP302 - Build user-friendly interfaces with Power Apps on top of your SharePoint & MS List data

Are your users looking for an “Easy” button when using lists? Make SharePoint and Microsoft Lists more web-user-friendly instead of SharePoint-user-friendly. This session will walk through Power Apps + Lists examples that put more solution-specific and context-specific actions in the hands of users and delivered via Teams. Instead of editing a SharePoint list item, changing a property, and hitting Save - add a button that makes an update with a single click. Users get the actions they need in the context that makes sense to them.

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

  • Gokan Ozcifci

    Microsoft Regional Director & MVP.

SPT302 - Mastering Microsoft Teams: Build your first app with Dataverse

Building intelligent and integrated apps within your organization is a must for everyone that embraces a hybrid workplace. Is that even possible from an end-user or maker perspective? Well, YES! After the “Better together with Power Apps and Automate” In this session, we’ll explore and learn how to customize Microsoft Teams (workplace) with the built-in Power Platform capabilities using Microsoft Dataverse. By attending this session you’ll gain insights on the business benefits of enabling and using Dataverse and the importance of Dataverse that is central to transforming any business process, from action to automation and from interaction to analysis. Be prepared for a lot of demos, live crashes, and real-world scenarios where Dataverse provides a low code data platform that allows your data to permeate all your apps - and in this session, we'll show you how from A to Z.

Friday, May 13th 2022, 10:20 am

  • Treb Gatte

    Microsoft MVP, MBA

BI302 - Converting Content into Data with SharePoint Syntex, AI Builder, and Power BI

According to Forrester, today’s organizations have 73% of their critical information locked away in their Content Estate, scattered amongst PDFs and other unstructured, hard to analyze file formats. Until now, the process to curate this information into analyzable data has been manual, time-consuming, and expensive. Today, industry leaders are using AI to combine their content information with structured data from the Data Estate to synthesize new business insights and drive innovation faster. Learn how you can use Microsoft’s new applied AI technology to enable this competitive advantage for your company. Using SharePoint Syntex, AI Builder, and Power BI, you see how to build a competitor product comparison with your own product. You’ll see how to: • Create an extraction model using AI Builder • Attach that model to a SharePoint library • Have SharePoint Syntex extract the data from the documents automatically • Use the new Power BI integration with SharePoint, using your competitor data with structured data for a holistic analysis.

Friday, May 13th 2022, 12:30 pm

  • Daniel Christian

    Microsoft Business Application MVP

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

  • Ben Vanderberg

    Principal Platform Evangelist - Adobe

PWR304 - From Dataverse to documents and back again

While data exists in Microsoft Dataverse, you often need to create documents with that data. Oftentimes, you might have documents that you want to populate that data back into your records in Dataverse. In the session we will learn: • How you can create data-driven and dynamic documents • How you can capture e-signatures on documents generated from Power Apps • How you can extract data from documents to populate in a record in Microsoft Dataverse

Friday, May 13th 2022, 1:50 pm

  • Treb Gatte

    Microsoft MVP, MBA

BI304 - Tracking Objectives and Key Results (OKRs) with Power BI Goals and SharePoint

Greatly improve the speed of your decision making by using Power BI Goals and SharePoint together to get relevant information easily. This session will introduce the new Power BI Goals functionality, discuss what are Objective and Key Results metrics, show you how to set up an (OKR) and tie it to data from SharePoint for automatic updating.

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.

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!