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

Tuesday, September 27th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

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

Tuesday, September 27th 2022, 9:00 am

  • Daniel Christian

    Microsoft MVP and MCT

WRK505 - Let's build a chat bot together

This beginner-level workshop gives you hands-on experience designing and developing your first Power Virtual Agent chatbot. We start off by first taking a closer look at all the features available and then build two bots, a static bot with all the data manually entered and then a dynamic bot which pulls the data using Power Automate flows. Then we switch over to Microsoft Teams and see all the features available there and how to use them to build chatbots are not additional cost.

Tuesday, September 27th 2022, 1:30 pm

  • Daniel Christian

    Microsoft MVP and MCT

WRK605 - 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. In the second half we'll look at building some Power Automate flows using buttons. We'll build an elegant canvas app to submit, edit and delete data. Our primary focus will be on the design features such as: • Screens: How many to build and for what reasons? • Navigation: Should I use buttons only or a gallery or a component? • Forms: Should I build my own form or should I use the Edit form? • Design: Branding ideas and responsive design scenarios • Data source suggestions Performance improvements suggestions.

Wednesday, September 28th 2022, 9:50 am

  • Daniel Glenn

    Microsoft MVP

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

Wednesday, September 28th 2022, 11:30 am

  • Don Kirkham

    Microsoft MVP | Enterprise Architect, DMI

APP102 - Creating multi-language PowerApps - the easy way

As more companies expand into markets around the globe, it is critical that your apps are able to easily handle multiple languages. We will discuss some options, then build a PowerApp that enables multiple languages using a simple Excel spreadsheet.

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

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and 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, September 28th 2022, 1:40 pm

  • Daniel Christian

    Microsoft MVP and MCT

PWR103 - Forms, Forms Everywhere but Which One Should I Pick?

Microsoft has a variety of no-code, low-code for forms and apps services available, so which one do I use? Join Daniel Christian, a Microsoft MVP and certified trainer, as he walks you through these form options available and provides guidance on when you should use which one. This is a demo heavy session with real-world examples.

Wednesday, September 28th 2022, 3:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI104 - Sharing PowerBI Reports with the World - 5 Things to Know

The Power BI Publish to Web feature is a powerful tool for sharing your reports with a wider audience. However, it brings with it a number of difficulties, challenges, and dangers. Before you use this capability, you should know when it is appropriate, what is possible, and how to design for it properly. This session will explore what the Publish to web feature is all about, and how you can take advantage of it effectively, and most importantly… safely.

Wednesday, September 28th 2022, 3:30 pm

  • Nick Brattoli

    Microsoft MVP and MCT

APP104 - Building your first Model-driven app with Power Apps as an IT Pro

When most people think about Power Apps, they imagine canvas apps. While those can offer a lot of design flexibility, sometimes it's necessary to build an interface quickly and focus on functionality. In this session, join Nick Brattoli as he demonstrates how to quickly build and deploy Power Apps to suit your data. We'll go over topics such as: • Differences between canvas apps and model-driven apps • Building your data model with DataVerse • Creating a basic model-driven app • Interacting with your data using Power Automate flows If you're already familiar with canvas apps and you want to see what else Power Apps can do, don't miss this one!

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.

Wednesday, September 28th 2022, 3:30 pm

  • Craig Jahnke

    Senior Manager - M365 Practice Lead at WM Reply
  • Jay Leask

    Microsoft MVP and PMP

SPT104 - Intro to Viva Insights and Workplace Analytics

Learn how Viva Insights can help you create a culture where people and business thrive through the power of MyAnalytics and Workplace Analytics. Viva Insights can use your most powerful dataset using insights from everyday work in Microsoft 365 to help you discover opportunities to optimize business processes and identify patterns that lead to success. This session will show you how you can measure the impact on business outcomes throughout a continuous cycle of discovery and change.

Thursday, September 29th 2022, 8:30 am

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

PLT200 - Intro to Microsoft 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

Thursday, September 29th 2022, 10:20 am

  • Eric Overfield

    Microsoft MVP, RD and MCT

BV202- One-Stop-Viva-Shop | Your Guide to all Facets of Microsoft Viva

Microsoft Teams has evolved into a highly productive tool that is much more than meets the eye. As many organizations are clamoring to connect disparate digital tools into an intuitive and holistic digital workspace, Teams has positioned itself as the single pane to your digital workplace. The recent launch of Microsoft Viva, Microsoft's employee experience platform, depends upon Microsoft Teams' unique capabilities as the central hub to a successful digital workplace. In this session, you'll learn how Microsoft Teams and the facets of Microsoft Viva connects the dots and can bring transparency, efficiency, and productivity to your workforce. Walk away with practical applications to configure and architect Microsoft Teams as the dashboard to your Microsoft 365 and Microsoft Viva empowered digital workspace. In this session: • Understand how Viva Connections, Topics, Learning, Insights, and additional modules integrate with Teams • Successful patterns when rolling out Viva components in your organization • Licensing and integration requirements

Thursday, September 29th 2022, 10:20 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

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

Power BI 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, September 29th 2022, 10:20 am

  • Wes Preston

    Microsoft MVP

APP202 - Build user-friendly interfaces with Power Apps for your SharePoint & Microsoft 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.

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

  • Gokan Ozcifci

    Microsoft MVP and RD

PLT202 - PowerApps and SharePoint: Better together.

Since Microsoft announced the long-term deprecation cycle for InfoPath, business users and power users have been waiting for better answers. Wait no longer! PowerApps is officially here as your InfoPath replacement, and even better – Microsoft is releasing PowerApps templates to get us started. First, we’ll talk through the basics, then we’ll cover how to use templates and finally, we’ll build a form from scratch. This session will help you get familiar with PowerApps so that you can go back to work feeling confident that you can provide great solutions, without having to wait on your development team. Come to my session and See how PowerApps can be used to display richer and more functional views of your data - now, directly in SharePoint and Teams with supported web parts and components.

Thursday, September 29th 2022, 2:00 pm

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

APP203 - Power Apps: Building Offline Apps Tips and Tricks

Power Apps is a powerful tool for "Citizen" developers to use when building applications for a variety of data sources. But how do you use a cloud based application when you have little or no Internet connectivity? In this talk we'll look at how to take a mobile Power App that was built using SharePoint as a data source and convert it to allow use of the app when offline. Along the way we'll talk about the critical design characteristics for an offline app and the limitations inherent in this approach.

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

  • Amarender Peddamalku

    Digital Transformation Leader and Microsoft Modern Work Practice Lead at Perficient

APP204 - Build external-facing websites using Power Apps portals

We'll learn how to create powerful external-facing websites that allow users outside their organizations to sign in with a wide variety of identities, create and view data in Microsoft Dataverse, or even browse content anonymously. Also, we'll learn to quickly create a website and customize it with pages, layout, and content. We'll dive into portals ALM (Application Lifecycle Management) using Microsoft Power Platform CLI tool to deploy/publish changes from Dev > QA > Production.

Friday, September 30th 2022, 9:00 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

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

Friday, September 30th 2022, 9:00 am

  • Haniel Croitoru

    Microsoft MVP

APP301 - Around the World in 60 minutes - How to create Enterprise-wide Multilingual PowerApps

Supporting multiple languages for corporations is a necessity in multilingual countries, such as Canada, Belgium, Italy, and others. The same applies to organizations having a workforce that is distributed across the globe. One common challenge in building solutions to support multilingualism is the creation and maintenance of such solutions as they evolve and more languages are added. In this session, we will implement a PowerApps framework for supporting multiple languages. Elements that will be covered include static labels, list entries, caching, and more.

Friday, September 30th 2022, 10:20 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

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

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

  • Vlad Catrinescu

    Microsoft MVP and MCT

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

Friday, September 30th 2022, 12:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI303 - 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, September 30th 2022, 12:30 pm

  • Wes Preston

    Microsoft MVP

APP303 - Case Study: Manage SharePoint News with Power Apps

As the complexity of a SharePoint page grows beyond the first few News web parts, the work of content managers and contributors also increases. This session walks through approaches to making it easier for users - via SharePoint, Teams, or mobile devices - to promote or demote posts or make posts show up in the right place without manually setting file properties.

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

  • Don Kirkham

    Microsoft MVP | Enterprise Architect, DMI

APP304 - Responsive Power Apps: Scale to all devices

While Power Apps are able to scale to devices of different sizes, the techniques to accomplish this can be confusing. In this session, we will explore how to design your app to be responsive to all devices, eliminating the requirement to build screens for specific sizes. Once you see how this works, you'll never go back to the multi-screen approach to scaling.

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.