Chicago, IL

Power Platform

Monday, July 26th 2021, 9:00 am

  • William Huneycutt

    ASPE Training | Upskill Tech

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, July 26th 2021, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

WRK201 - A Beginner’s Guide to Power BI for SharePoint Users

NOTE: YOU WILL NEED A COMPUTER WITH THE LATEST VERSION OF POWER BI DESKTOP INSTALLED PRIOR TO WORKSHOP TIME. THIS IS A HANDS ON WORKSHOP. Need to create stunning dashboards from your SharePoint data? Yes you do! In this workshop, 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 Project reporting, so that you are able to use Power BI immediately for your needs.

Monday, July 26th 2021, 1:30 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

WRK301 - Power BI for SharePoint Users Deep Dive

NOTE: The workshop assumes you have a working knowledge of Power BI and Data Concepts. This is intended as a hands on class. A PC with Power BI Desktop installed is required to get the most out of it. However, you are welcome to attend if you simply want an overview of advanced Power BI techniques. Now that you’ve attended my morning workshop and understand the basics of Power BI for SharePoint Users, we’ll go deeper into what you need to deliver professional looking reports and dashboards. This half day workshop will be spent on learning tips and techniques from the pros on delivering Power BI based apps that are easy to use and are maintainable. In this workshop users will learn: • 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 visualization best practices to ensure you can tell your digital story effectively • Learn best practices for maintaining content with your organization Who should take this course: If your company uses Office 365 or SharePoint 2013/2016 and you are either 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

Monday, July 26th 2021, 1:30 pm

  • Wes Preston

    TrecStone Owner/Consultant | Microsoft MVP

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

Use Power Apps to build custom business apps, forms, and flexible connections to data. As Microsoft’s successor to InfoPath, bring modern forms capabilities to dozens of data services with M365, Teams, MS Lists, and SharePoint at the top of the list. Power Apps also address business’ demand for mobile apps by creating solutions that work on a variety of devices. Come and learn what power users need to get started with Power Apps. Walk through a variety of scenarios where PowerApps extends or integrates with SharePoint and Teams. - Replace existing SharePoint forms with embedded Power Apps forms - Connect Power Apps to MS Lists and SharePoint list data - Create Power Apps from SharePoint data - Explore Power Apps capabilities and options - Discuss business solutions and approaches using Power Apps, Teams, MS Lists, SharePoint and the Microsoft stack as well as pointers on what to use when. Note: Power Apps integrates directly with Teams, MS Lists, SharePoint Online, and other cloud-based platforms and can also be used with later versions of on-premises SharePoint using gateways.

Tuesday, July 27th 2021, 9:00 am

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

WRK406 - 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, July 27th 2021, 9:00 am

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner - MVP, MBA, MCSM
  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

WRK502 - Hands-On Power Automate Workshop - Fundamental

Power Automate/Flow is the successor to SharePoint Designer workflow and the future of process automation for SharePoint. While it is much more than a SharePoint-only tool, this session will focus on providing you with the skills to get started right away with SharePoint automation. In this demo-rich workshop, you’ll learn by doing with hands-on labs. What we'll cover during the session: • 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 Demo environment is provided ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Tuesday, July 27th 2021, 1:30 pm

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner - MVP, MBA, MCSM
  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

WRK602 - Hands-On Power Automate Workshop - Intermediate

In this Power Automate/Flow workshop, you’ll learn by doing with hands-on labs. The workshop is geared towards participants who either have introductory knowledge of Power Automate/Flow or have attended this SharePoint Fest's morning/fundamental workshop. What we'll cover during the session: • Flow expressions • Advanced approval scenarios, e.g. escalation • Interacting with larger data sets in SharePoint, using OData Filter, Loop • Must-know nuggets from real-world solutions Demo environment is provided ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Tuesday, July 27th 2021, 1:30 pm

  • Daniel Christian

    Microsoft Business Application MVP

WRK606 - 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- • Adding headers, footers and navigation icons using components, • Improving the look and feel of data cards in galleries • Pop-up messages

Wednesday, July 28th 2021, 9:50 am

  • Liz Sundet

    Program Manager - SharePoint/OneDrive

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, July 28th 2021, 9:50 am

  • Wes Preston

    TrecStone Owner/Consultant | Microsoft MVP

PWR101 - Intro to Power Apps for Microsoft Teams and SharePoint

If you create business solutions with SharePoint lists; If you surface information and solutions via Microsoft Teams or SharePoint; 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 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

Wednesday, July 28th 2021, 11:10 am

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

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, July 28th 2021, 11:10 am

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

FLO102 - Expressions in Power Automate and Flow

A deep knowledge of Flow 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 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!

Wednesday, July 28th 2021, 2:00 pm

  • Mike Fitzmaurice

    VP - North America, WEBCON

FLO103 - Stage-Based Workflows: Principles and Practices

One feature that differentiates the Microsoft Power Automate (Flow) Premium plan is Business Process Flows; they're the Power Automate platform's implementation of stage/state machine logic. SharePoint Designer 2013 supports it, as do ISVs like WEBCON and Nintex. They allow workflows to move backwards, sideways, or any other way. They explain processes more easily. They're easier for users to participate in design. They're easier to modify. They're just, well, better. 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.

Wednesday, July 28th 2021, 2:00 pm

  • Raj Krishnan

    Microsoft Corporation; Cloud Solution Architect

OFF103 - Supply Chain automation with Power Apps and AI Builder

Tracking multiple activities or processes from end to end accurately and navigate through them at various stages is a common supply chain challenge in manufacturing. In this session we will discuss how to leverage Power Platform, AI Builder and Office 365 to track an end to process toward the completion of assembly of products. We leverage QR Code, Form Recognizer and factory floor data collection application to build the solution.

Wednesday, July 28th 2021, 3:20 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

BI104 - 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, July 28th 2021, 3:20 pm

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner - MVP, MBA, MCSM

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

Wednesday, July 28th 2021, 3:20 pm

  • Alex Terentiev

    Office Development MVP. Custom Solutions Architect, Lead Developer at Sharepointalist Inc.

AZR104 - Create Your First Bot to Communicate with SharePoint Lists

The session: 1. overviews Azure Bot Service and Bot Framework 2. provides steps on how to register needed Azure resources for the bot 3. Explains bot state and dialogs 4. Showcases how to authenticate a bot to work with Microsoft Graph 5. Shows how to use Microsoft Graph to work with SharePoint list items

Wednesday, July 28th 2021, 4:40 pm

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

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

Wednesday, July 28th 2021, 4:40 pm

  • Daniel Christian

    Microsoft Business Application MVP

PWR105 - Make use of all the Power Apps Admin features and also some free tools!

The Power Platform Admin Center comes with several out-of-box features that provides you the ability and the confidence to govern your apps, flows and connectors. Join Daniel Christian, a Business Solutions Microsoft MVP and an early adopter of the Power Platform, as he shows you how to setup your Power Platform administration using Azure Active Directory Security Groups and also CDS Security Groups. Finally, he'll also show you all the free tools available to make your admin tasks easy and automated as well.

Wednesday, July 28th 2021, 4:40 pm

  • Daniel Glenn

    Collaboration Practice Lead @ InfoWorks, Inc., Microsoft MVP

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

Thursday, July 29th 2021, 9:00 am

  • Christina Wheeler

    Principal Solution Architect & Trainer, MVP

BI201 - Standardizing Power BI Reports with Custom Themes & Templates

Power BI is powerful. Not only does it have an amazing set of visuals you can use out-of-the-box it also provides the ability to apply report themes and create templates. There are a set of themes already provided however most of the time organizations have corporate colors they want to use for their reports and want a standardized template. In this session, you will learn the following: • Using visual elements to enhance your Power BI report • Displaying images in a table, matrix and slicer • Creating visual appealing tooltips based on report pages in Power BI Desktop • Creating and applying custom report themes • Extracting and re-using custom themes from existing reports • Creating and using report templates

Thursday, July 29th 2021, 9:00 am

  • Sarah Haase

    Microsoft MVP

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

Thursday, July 29th 2021, 9:00 am

  • Mark Rackley

    MVP, CSO at PAIT Group and SharePoint Hillbilly

TMD201 - It’s Time to Modernize Your Company FAQ with a No-Code Bot in Microsoft Teams

The thought of creating a bot may sound like a daunting task to anyone without a technical background. I know as a developer when I was tasked with writing a Question and Answer bot I was apprehensive as to what all it would entail. It turns out the process is extremely simple and requires no technical abilities whatsoever. In fact, after creating the bot it struck me that the Question and Answer bot is the ideal bot to replace your company’s FAQ. We all have them. Frequently Asked Questions. Have you ever found a FAQ usable though? It’s a lot of search and reading and unless you search for the exact right keyword then you may not even find what you are looking for. Attend this session and learn: • How ANYONE can create a QnA Bot and deploy it to Teams • How to source FAQ information from spreadsheets, web pages, and other sources • How to take advantage of AI Cognitive Services to determine user intent when they ask questions • ALL without writing a line of code! It’s time that you modernize your company’s FAQ

Thursday, July 29th 2021, 10:30 am

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI202 - 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, July 29th 2021, 10:30 am

  • Daniel Christian

    Microsoft Business Application MVP

PWR202 - Pro Tips to improve Power Apps performance

Now that you've gotten familiar with building some amazing forms or apps using zero or low-code, let's focus our attention on improving its performance. In this session, Daniel Christian, a Business Solutions Microsoft MVP and an early adopter of the Power Platform, will cover how you can plan building design of your app, choosing suitable functions and leveraging tools to significantly impact your app performance. This is a demo heavy session where you'll first-hand see what you should and should not do.

Thursday, July 29th 2021, 10:30 am

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner - MVP, MBA, MCSM

FLO202 - Building Modern Approvals: Using Microsoft Power Automate (Flow)

Approval workflows have always been one of the most important tools when building business processes in SharePoint. In this talk we will walk through everything you need to know to build modern approval workflows using Microsoft Power Automate. We'll start with the new built-in "Request sign-off" Flow and work out to an approval Flow with multiple sign-offs. Along the way I'll demonstrate how to retain an audit trail and troubleshoot your approval flow.

Thursday, July 29th 2021, 10:30 am

  • Prashant G Bhoyar

    Microsoft AI MVP, Solution Architect at Withum

ADM202 - PowerShell for Power Apps and Power Automate

In this demo-driven session, we will cover how to use PowerShell for Power Apps and Power Automate. You will learn: • How to use PowerShell for Power Apps and Power Automate? • Managing Tenant Level Settings • Creating and Managing environments • Managing Power Apps and Power Automate Owners • Managing Power Apps and Power Automate Connections • Managing Canvas Apps • Pulling Usage Statistics • Best Practices

Thursday, July 29th 2021, 1:20 pm

  • Daniel Glenn

    Collaboration Practice Lead @ InfoWorks, Inc., 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, July 29th 2021, 1:20 pm

  • Mike Fitzmaurice

    VP - North America, WEBCON

FLO203 - Building Business Processes that Can & Will Evolve: Product-Neutral Principles

Far more than data management apps, workflow solutions need to factor in the need for frequent change. You should expect even the best-designed models and applications to be regularly modified -- and that's a good thing. This has an impact on how to design processes, how to create forms and reports, how to connect to external data, and how to maintain internal data. This session will talk about reasons why workflow solutions need to be modified so often, why you should embrace this, and strategies and tactics for addressing it. Its advice can be applied to Microsoft Power Automate (Flow), SharePoint Designer, WEBCON BPS, FireStart, Nintex, K2, or most anything else.

Thursday, July 29th 2021, 2:40 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

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, July 29th 2021, 2:40 pm

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

FLO204 - Real World Power Automate

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 and problems encountered by Flow developers in the real world. We will explain the issues and look at each solution in detail.

Thursday, July 29th 2021, 4:20 pm

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI205 - There's No Time Like the Present - Real Time Reporting with 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.

Thursday, July 29th 2021, 4:20 pm

  • Wes Preston

    TrecStone Owner/Consultant | Microsoft MVP

PWR205 - Power Apps: A New Approach to the Traditional SharePoint List View

PowerApps is an excellent tool for custom forms and facilitating business processes (with Microsoft Flow). Did you know PowerApps is also capable of building dramatically better list views? It's no coincidence that PowerApps are surfaced in the SharePoint interface via the View dropdown control. 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, July 29th 2021, 4:20 pm

  • Prashant G Bhoyar

    Microsoft AI MVP, Solution Architect at Withum

FLO205 - Advanced Power Automate

Power Automate is the logical successor of SharePoint Designer Workflows. It helps us to create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data and to do much more. In this demo-driven session we will cover the advanced features of the Power Automate like Expressions, Advanced approval scenarios, nested flows, calling SharePoint REST APIs, and how can we use them to create sophisticated business solutions. You will learn: • Expressions in Power Automate • Advanced Approvals • How to consume SharePoint REST Endpoints using Power Automate? • How to leverage Power Automate to implement the real-life business solutions in Office 365/ SharePoint Online? • Power Automate Best Practices • How to convert Power Automate to Logic Apps?

Friday, July 30th 2021, 9:00 am

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI301 - Telling data stories with Power BI

Struggling to make your data tell the story that you know is hiding in there? Sick of staring at static spreadsheets and wishing that there was a way to visualize things so that the data could speak for itself? Are you tired of doing the same analytical motions over & over again instead of being able to use a repeatable process that will give you time back to do your actual job? Welcome to the wonderful world of Power BI where all of these things are achievable. In this session you will learn powerful ways of making your data come to life using Power BI Desktop & the Power BI Service. Whether your data is stored in a Microsofty way in Excel, SQL Server, SharePoint Online lists, CSV files on some old file server, you will learn to unlock the data within & bring to life the stories hidden in the data.

Friday, July 30th 2021, 9:00 am

  • Mike Fitzmaurice

    VP - North America, WEBCON

FLO301 - Which Tool is Right for Which Business Process and/or Automation Requirements

Power Automate is a great fit for many automation problems. But there's more than one kind of automation problem, and some business process solutions require more than just automation. Some automation problems 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. There's also a whole class of applications that focus on much more than automated activity, factoring in roles, assets, user interfaces, security, task logistics, strategy and tactics, and more. We'll talk about that, too. 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, July 30th 2021, 10:40 am

  • Wes Preston

    TrecStone Owner/Consultant | Microsoft MVP

PWR302 - Power Apps: New Approaches for SharePoint 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, July 30th 2021, 10:40 am

  • Prashant G Bhoyar

    Microsoft AI MVP, Solution Architect at Withum

FLO302 - Battle Royal: Power Automate (Microsoft Flow) vs Azure Logic Apps

Power Automate is built on the top of Logic Apps and offers a comprehensive offering to build low code/no-code automation. Often the developers and architects have to decide which product to use while building automation. In this demo-driven session, we will cover the in-depth the key differences between Logic Apps and Power Automate and their suitable use cases. We will also cover the pricing and the extensibility model. You will learn : • Key differences between Logic Apps and Power Automate • How to extend Microsoft Flow using Logic Apps • Best Practices of Logic Apps and Power Automate

Friday, July 30th 2021, 1:00 pm

  • Daniel Christian

    Microsoft Business Application MVP

PWR303 - Power Apps with Large Data Sets

This session demonstrates how Power Apps can use large data sets and still be fully functional. Join Daniel Christian, a Microsoft MVP and an early adopter of the 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 to avoid any delegation issues.

Friday, July 30th 2021, 1:00 pm

  • Scott Shearer

    SharePoint, Flow and Office 365 Evangelist and Microsoft MVP

FLO303 - Take Your Power Automate Skills to the Next Level!

This demo intensive Power Automate session will cover such topics as approval escalation, parallel branches, expressions, using variables and more. Power Automate a is improving all the time and you'll see the latest enhancements. Finally, you'll see how to accomplish automation tasks that you now do in Designer workflows through Flow. Attend this session and take your Power Automate and Flow skills to the next level!

Friday, July 30th 2021, 1:00 pm

  • Bob German

    Building Solutions at Microsoft with Office 365 and Microsoft Azure

TMD303 - Building Low-code Bots for Teams and Beyond with Microsoft Bot Framework Composer

Chatbots are very popular these days and are especially helpful in Microsoft Teams. A quick learning curve, mobile friendliness, and the ability to work alongside groups of people in chat applications makes them a natural for today’s workforce. In this session you’ll learn how to write Bots using a free tool from Microsoft called Bot Framework Composer. You'll learn how to use natural language understanding (LUIS) and search technology (QnA Maker) to make a bot that can respond to user's requests, and also how to use Language Generation to dynamically generate natural-sounding responses. You'll also learn how to use adaptive cards in your bot, and how to call out to REST services such as the Microsoft Graph. Bot building is for everyone! Come learn how to get started.

Friday, July 30th 2021, 2:20 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

BI304 - Managing Goal Status and OKRs using 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 Goals and Objective and Key Results(OKR) metrics, show you how to set up your metrics using data from SharePoint for automatic updating.

Friday, July 30th 2021, 2:20 pm

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner - MVP, MBA, MCSM

FLO304 - Building Modern Approvals using Microsoft Power Automate: Advanced Concepts

The introduction of the Approvals Actions in Microsoft Power Automate has simplified the process of creating Approval Workflows. In this talk we’ll go beyond the process of building basic parallel or serial approval flows and look at advanced techniques that can be used to take them to the next level. We’ll demonstrate solutions for the following: • Applying custom formatting to the approval email • Recording approval results and comments • Setting SharePoint content Approval status • Forwarding an approval if the approver is out of the office • Escalating an approval that hasn’t been responded to • Sending periodic reminders about pending approvals • Building an approval workflow for an adjustable list of approvers