Dallas, Texas

Power Platform (All)

Monday, August 8th 2022, 9:00 am

  • Scott Shearer

    Microsoft MVP and MCT
  • Wes Preston

    Microsoft MVP

WRK103 - 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, August 8th 2022, 9:00 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

WRK106 - 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, August 9th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

WRK404 - 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, August 9th 2022, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

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

Tuesday, August 9th 2022, 9:00 am

  • Nick Brattoli

    Microsoft MVP and MCT

WRK503 - Building an Employee Recognition Solution with SP, Power Apps, Power Automate and 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!

Tuesday, August 9th 2022, 1:30 pm

  • Scott Shearer

    Microsoft MVP and MCT

WRK603 - Approvals in Power Automate

Do you have a requirement for a process to approve documents or requests of almost any type? Power Automate can meet that need! In this session, you’ll learn the various methods of doing approvals in Power Automate and when to use each method. Live demos will be used to explain each concept including escalating an approval when no action has been taken and sending reminder emails. While this session will focus on approvals for SharePoint, we'll also discuss and demo using the Power Automate approval engine with a variety of connectors such as Microsoft Forms. Attend this session and take away the knowledge you need to immediately start using Flow for Approvals.

Wednesday, August 10th 2022, 9:50 am

  • Liz Sundet

    Program Manager at Microsoft

BI101 - Getting started learning Power BI

You've heard people say Power BI is awesome. You've seen lots of reports and think, wow, I wish I could produce that. Or, maybe you're just curious what all the fuss is about. Come learn where to get started with PowerBI from the vocabulary to how to connect data together. We will cover the basics as well as creating dynamic reports that will be sure to impress any executive.

Wednesday, August 10th 2022, 9:50 am

  • Scott Shearer

    Microsoft MVP and MCT

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, August 10th 2022, 11:30 am

  • Heidi Jordan

    SharePoint Solutions Specialist at High Plains Technology

APP102 - Power Apps: Tips From a First-Time User

Having troubles getting started with Power Apps? You're not alone. As InfoPath support comes to an end, it's imperative that users understand the next form designer baked into SharePoint Online. In this session, I'll share what I learned as a first-time user of Power Apps - both what works and what doesn’t. Together, we will cover the entire lifecycle of a SharePoint Online list form and address the basics: How do I actually build my first form? Where do I add fields and their defaults? Can I make it look pretty? Once I publish the form, how do users fill it out? This session will be peppered with my own personal pros and cons, pitfalls to be aware of but mostly centered around the things a user should consider before making the switch from any form designer to Power Apps.

Wednesday, August 10th 2022, 11:30 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • 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, August 10th 2022, 11:30 am

  • Luc Labelle

    Microsoft MVP and MCT

FLO102 - Get started with Robotic Process Automation using Power Automate UI Flows

Join us in this session to get started with the new Power Automate UI Flows service, Microsoft’s Robotic Process Automation solution. During this session we will take a tour of the Power Automate UI Flows application interface, look at the available controls and discuss some of the basic concepts around Robotic Process Automation. We will show you in a step-by-step demo how you can record user actions such as mouse clicks, keyboard use, and data entry, and then replay those actions to automate this process.

Wednesday, August 10th 2022, 11:30 am

  • Ben Vanderberg

    Principal Developer Evangelist at Adobe

PWR102 - Automating document processes with Microsoft Power Automate

There are so many necessary documents for an organization, and being able to help automate them can make a huge difference. In this session, we will see how you can automate that in Microsoft Power Automate with Adobe PDF Services and Adobe Sign: • Generate Word and PDF documents from data using Adobe Document Generation • Protect, Combine, OCR, and perform other actions on PDFs • Send and capture e-signatures

Wednesday, August 10th 2022, 1:40 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI103 - Data Mining Office 365 & SharePoint with Power BI

See how to use Power BI to mine the data you have in SharePoint and Office 365. We’ll pull data from lists, libraries, triggered activities using Flow and from Search and create beautiful reports and dashboards easily from it. We’ll also show you how this can be automated and saves you time from copying and pasting data into different places.

Wednesday, August 10th 2022, 1:40 pm

  • Prashant G Bhoyar

    Microsoft MVP and MCT

TMD103 - Building No Code Chat-Bots in Microsoft Teams using Power Virtual Agents

Bots are Hot. 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 and deploy it to Microsoft Teams. You will learn: • What are Power Virtual Agents? • Bots in Microsoft Ecosystem • What is Azure Bot Service? • How to call Power Automate from Power Virtual Agents? • How to create bots using Power Virtual Agents? • How to deploy the Bots to Microsoft Teams?

Wednesday, August 10th 2022, 1:40 pm

  • Geetha Sivasailam

    Microsoft MVP

PWR103 - Power BI + Power Apps + Power Automate = Better Together

Want to amplify actionable data insights and accelerate better decision making? Then this session is for you where we'll look at how organizations can benefit from the exciting possibilities of using Power BI, Power Apps and Power Automate together. We will walk through best practices, things you should know to take full advantage of the tools and real-life examples. Learn how you can seamlessly combine data visuals on Power BI dashboards with an added layer of apps and cloud flows to enable write-back capabilities and integration with numerous back end services.

Wednesday, August 10th 2022, 3:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

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

Thursday, August 11th 2022, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

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

Thursday, August 11th 2022, 9:00 am

  • Luc Labelle

    Microsoft MVP and MCT

BI201 - Build smarter Power Platform solutions using Artificial Intelligence

Embed AI capabilities in your Power Apps, Microsoft Flow and Power BI solutions and let Artificial Intelligence do the work for you. Join us in this session and learn how to leverage AI capabilities from Power Platform solutions. We will demonstrate how AI can help you and your organization save time and money by augmenting simple applications and processes. In this session we will work with simple use cases, based on real business requirements that all attendee can relate to.

Thursday, August 11th 2022, 10:40 am

  • Wes Preston

    Microsoft MVP

APP202 - Intro to Power Apps for Microsoft Teams and SharePoint

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

Thursday, August 11th 2022, 10:40 am

  • Scott Shearer

    Microsoft MVP and MCT

FLO202 - Real World Power Automate

Looking for practical solutions to common issues encountered when writing Flows? Then this demo-rich session is for you. Our time will be devoted to working through common questions asked by and problems encountered by real world Power Automate developers and posted on the Power Automate Community site (https://powerusers.microsoft.com). We will explain each issue and look at each solution in detail (and have some fun in the process).

Thursday, August 11th 2022, 1:20 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI203 - Best practices for using Power BI and Paginated Reports

Now that Paginated Reported (what we used to call SSRS reports) are available in the Power BI service, numerous questions arise as to when to use which report type. Each type has a different design goal, with different strengths and weaknesses and it is important to know what they are. The fact that both now exist in the Power BI service and well as on premises leads to some interesting opportunities for synergy. This session will dive deep on how both types of reports work, and what's needed to get the most out of them. It will also demonstrate cases that call for either type, and identify when the use of both is appropriate. If you are a Power BI user that wants to do reporting AND analytics, this is a session for you.

Thursday, August 11th 2022, 1:20 pm

  • Mark Rackley

    Microsoft MVP

TMD203 - An Introduction to Power Virtual Agents for Microsoft Teams

Over the past few years, it has become increasingly easier to create powerful bots with little to no code. Now almost anyone can quickly create a deploy a chat bot with ease. Power Virtual Agents is a premium add-on to the Power Platform that allows you to create and deploy such bots. As part of Dataverse (previously called Project Oakdale) many Microsoft 365 subscribers have access to Power Virtual Agents for Microsoft Teams. These chat bots are covered under their Microsoft 365 licensing and require no premium licensing to develop, deploy, or use. In this session attendees will learn: 1) How to create / deploy chat bots in Teams 2) How to create Topics, use branching logic, and prompt users for input 3) Add even more power to their chat bots using Power Automate flows. All without any additional licensing!

Thursday, August 11th 2022, 2:40 pm

  • Ben Vanderberg

    Principal Developer Evangelist at Adobe

APP204 - 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, August 11th 2022, 2:40 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

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

Thursday, August 11th 2022, 2:40 pm

  • Mark Rackley

    Microsoft MVP

FLO204 - Advanced Power Automate Flows for Every Day Use

The Power Platform has changed the landscape for Citizen Developers giving them more power than ever before in Office 365. It's time to go beyond the basics and approval workflows to learn to create advanced functionality that maybe you never considered before as a possibility in Power Automate. Attendees to this session will learn how to build advanced Power Automate Flows for things like record management and auto tagging of documents opening up a new world of possibilities.

Thursday, August 11th 2022, 2:40 pm

  • Nick Brattoli

    Microsoft MVP and MCT

PWR204 - Building an employee recognition solution with SP, Power Apps, Power Automate and 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 session, join Nick Brattoli as he shows you how to build an employee recognition application from scratch using Power Apps, Power Automate, and even Power BI! He’ll discuss and demonstrate 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!

Thursday, August 11th 2022, 4:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI205 - There's No Time Like the Present - real time and low latency data in Power BI

Power BI has many options for keeping your data up to date, but what happens when scheduled refreshes simply aren't enough? What do you do when real time or near real time reporting on your data is necessary? Fortunately, Power BI has you covered here as well. From real-time datasets, to Direct Query and the Aggregations feature, there are more than a few options for accomplishing this goal, but they all do come with a few tradeoffs. This demonstration laden session will examine all of the techniques available to Power BI for reporting on your data in real time, highlight some of the things to watch out for, and how to design for them. If you need your data more up to date than what refresh schedules can provide, then this session is for you.

Friday, August 12th 2022, 9:00 am

  • Wes Preston

    Microsoft MVP

APP301 - Power Apps: New Approaches for List-based Data Solutions

Break free of the limitations of SharePoint lists. Power Apps integration with SharePoint introduces new options for Power Users to access, store, or extend existing data solutions beyond the boundaries of traditional lists. In this session we’ll cover new locations for data storage, new capabilities of these containers, and the pros and cons of choosing one over the other while still surfacing solutions via SharePoint or Teams.

Friday, August 12th 2022, 10:20 am

  • Paul Papanek Stork

    Microsoft MVP, MCT, MCSM and MBA

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

Friday, August 12th 2022, 10:20 am

  • Daniel Glenn

    Microsoft MVP

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

Friday, August 12th 2022, 10:20 am

  • Scott Shearer

    Microsoft MVP and MCT

FLO302 - Expressions in Power Automate

A deep knowledge of Flow expressions is critical to maximizing the power of Flow. 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 Flow and want to "step up your game" with the use of expressions, attend this session!

Friday, August 12th 2022, 12:30 pm

  • Luc Labelle

    Microsoft MVP and MCT

APP303 - Customize your SharePoint online forms with Power Apps

You’ve customized your all SharePoint forms with InfoPath and your organization is now moving to SharePoint online? Not a problem, join us in this session and learn how to use Power Apps to customize your SharePoint online forms. During this session we will take a tour of the Power Apps Studio application, look at the available controls and discuss the basic concepts of Power Apps. We will also, perform a step-by-step demo showing you how to create a multi-tab SharePoint online form integrating corporate branding, user driven content and simple business logic.

Friday, August 12th 2022, 12:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

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

Friday, August 12th 2022, 1:50 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI304 - Unlocking SharePoint’s Content Services data with SharePoint Syntex and 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.

Friday, August 12th 2022, 1:50 pm

  • Mark Rackley

    Microsoft MVP

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