Monday 9:00 AM - 5:00 PM · Room 421-422

Advanced Power Apps and Power Automate: Workarounds for Common Problems

Paul Papanek Stork

Don't Pa..Panic Consulting, Owner

Spend any amount of time in the Power Platform forums and you will begin to see a lot of 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: • Morning: Power Apps ○ Delegation ○ Working with Dates and Times ○ Conditional Formatting of data ○ Passing Data to and Retrieving Results from a Flow ○ Using Solutions to package Apps & Flows • Afternoon: Power Automate ○ New Copilot Support ○ Using Conditions and Switches effectively ○ Handling Loops and Parallel Branches ○ Working with Large Data Sources ○ Implementing Error Checking/Correction ○ Improving Performance

Monday 9:00 AM - 5:00 PM · Room 423-424

Power Apps and Power Automate (Flow) for M365/SharePoint Bootcamp

Scott Shearer

Microsoft Power Platform Evangelist and MVP

Wes Preston

Founder and independent consultant working with platform alignment and no-code solutions with M365 and Power Apps

Work through common business use cases to see how Power Apps and Power Automate - with their Copilot capabilities - fit into your toolset extending M365, SharePoint, Lists, and Teams and more.

This intro workshop will cover platform basics, dig in with demos, and then let you "take the wheel" walking through hands-on examples to build a solution as we work through the day building on top of Microsoft Lists.

Attend this workshop to get a foothold with the Power Platform. Gain the skills you'll need to immediately extend List capabilities and start customizing your Microsoft 365, SharePoint, and Teams sites with Power Apps and Power Automate.

You'll learn about the different types of Flows that can be used with Power Automate and will create basic Flows yourself. Then, see how Flows integrate with Power Apps you've built and the list data behind them. Your instructors will be there to assist throughout the day with your questions.

Notes and Requirements: 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.

We will be using Power Apps, Power Automate, Microsoft Lists, Teams, SharePoint and other Microsoft 365 components in our labs. Attendees are encouraged to setup trial environments prior to attending. Instructions will be made available.

If you will be using a company-provided laptop and will not be using your corporate tenant, please verify that you are able to connect to the Microsoft 365 environment that you will be using prior to arrival.

Monday 9:00 AM - 5:00 PM · Room 432

Hands-On: Azure, ChatGPT, Azure OpenAI For Power Platform Developers Masterclass

Prashant G Bhoyar

6 x Microsoft AI MVP| 3 x Microsoft Business Applications MVP| Speaker| Author| Leading AI Architect | Microsoft Certified Trainer, AI Architect at AIS

Gartner predicts, “by 2024, over 65% of medium to large enterprises will have adopted a Low Code Application Platform as one of their strategic application platforms.” Microsoft Power Platform is a low-code platform for rapidly building customized end-to-end business solutions. It consists of five product areas: Power Apps, Power Automate, Power BI, Copilot Studio, and Power Pages. Each area can be used individually or together. Thanks to native integration with Azure, developers can use their cloud development skills to extend Microsoft Power Platform with different Azure services. With a low-code integrated development approach, business goals can be achieved faster and free up time for the developers.

In this hands-on workshop, we will cover how to use Azure for custom development in Microsoft Platform services like Power Automate, Power Apps, Power Pages, Copilot Studio, Dataverse, and Power BI.

We will cover: • Microsoft Azure Key Concepts • How does Power Platform use Azure? • How can fusion teams take advantage of Microsoft Azure and Microsoft Power Platform? • Authentication and Authorization in Azure • Azure + Power Automate • Azure + Power Apps • Azure + Power Pages • Azure + Copilot Studio • Azure + Power BI • Azure + Dataverse • PowerFx • Copilots in the Power Platform • Azure OpenAI + Power Platform • ChatGPT + Power Platform • Custom Connectors in Power Platform • What are Azure Functions? • What are Logic Apps? • What is Azure Bot Service? • How to create an enterprise-grade app using Azure, ChatGPT, Azure OpenAI, and Microsoft Power Platform?

At the end of the workshop, attendees will have a working knowledge of Azure, Azure OpenAI, and how to use it to implement the customizations in the Microsoft Power Platform.

Access to Azure, Azure Open AI, and Microsoft Power Platform ( Power Apps, Power Automate, Copilot Studio, and Power BI ) will be provided to create the customization. The target audience of this hands-on workshop is Developers, Power Users, and IT Pros who want to get into development.

Please note: Attendees will need to bring their laptops with internet access and modern browsers like Microsoft Edge, Google Chrome, Firefox, and Safari. The tablets will not work.

Monday 9:00 AM - 5:00 PM · Room 434 (workshops only)

Microsoft 365 & The Power Platform - The Ultimate Starter Kit

Daniel Glenn

Microsoft MVP, Owner and Microsoft 365 Consultant at CollabFront

Microsoft 365 is the world's leading productivity suite that empowers you to work from anywhere, on any device, with a range of cloud-based apps and services. Microsoft’s Power Platform is a set of low-code or no-code solutions that enable you to build custom apps, automate workflows, and analyze data. In this workshop, you will be provided with a detailed exploration of these platforms, incorporating examples from real-world applications. We will of course look at how Copilot integrates with each product along the way! This information is useful if you've moved to the cloud, are thinking about moving, or are still exploring its value.

Some of the topics covered: • An overview of Microsoft’s cloud platforms and the evolution of collaboration. • An introduction and best practices for collaborative work in Microsoft 365, encompassing Microsoft Teams, SharePoint, and Viva Engage. • A primer on the Power Platform's favored tools: Power Automate, Power Apps, and Power BI. • An in-depth look at the workings of Microsoft 365 Groups. • Hands-on exercises and examples for integrating the Power Platform and Microsoft 365 to achieve business goals – bring your laptop and have company permission to use the services covered.

This starter kit is designed to enhance your understanding of the features within your cloud platform and learn how it can be leveraged within your organization.

Tuesday 9:00 AM - 5:00 PM · Room 421-422

Power Platform with Copilot and AI: A master class for every Information Worker

Gokan Ozcifci

Consultant. Entrepreneur. Microsoft Regional Director & MVP.

Mike Maadarani

Microsoft MVP, Cloud Solution Architect, MCM Consulting

In a world where digital transformation is key to staying ahead, mastering the tools that drive innovation is essential. This workshop is designed to empower users ranging from beginners to experienced, with the knowledge and skills to leverage Microsoft Power Platform's full potential, enriched by Copilot for Power Platform.

Our workshop will explore the entire Power Platform ecosystem, including: Power Apps Copilot, Power Automate Copilot, Copilot Studio, AI Builder, Power Pages Copilot, and Dataverse.

This workshop is designed to be interactive and hands-on, as it is free today, with real-world examples and exercises that ensure every participant can apply what they've learned to their own work environments. Whether you're an end user looking to simplify daily operations or a power user seeking to build sophisticated solutions, this workshop will equip you with the knowledge of AI to innovate and drive impact.

Join Gokan and Mike, Microsoft MVPs, Microsoft RD, and MCTs, for an engaging and informat

Tuesday 9:00 AM - 12:30 PM · Room 440-442

SharePoint Data Modeling: From Requirements to Usage

Paul Papanek Stork

Don't Pa..Panic Consulting, Owner

Data modeling is an essential first step in any Power Apps or Power Automate project. Power apps provides a user interface for information stored in a data source and Power Automate creates workflows that manipulate data stored in a data source based on specific events or triggers. Data modeling is difficult enough for professional developers, but it is even harder for citizen developers. Citizen developers usually have little exposure to concepts like data normalization and often can’t use true relational databases like SQL or Dataverse because of the cost of Premium licensing. So, they are left trying to figure out how to build their flows or apps using data stored in SharePoint lists or Excel spreadsheets. In this workshop I will show you some real-world techniques for doing data modeling. I’ll start with a typical project requirements definition and show you how to easily convert it into an Entity Relationship model. Next, I’ll show you how to map that Entity Relationship model onto a set of SharePoint lists. Once I have the lists designed, I’ll show you how to use them in a Power App and a flow. Along the way I’ll walk you through what you need to know about using SharePoint as a data source, including: • What Column types work well and which ones to avoid • When to use (or not use) Lookup columns to create relationships between lists • How to plan for Security in SharePoint • Other Common issues I’ll focus on SharePoint in the workshop but the techniques I teach you are also applicable for other data sources like Excel, SQL or even Dataverse.

Tuesday 9:00 AM - 12:30 PM · Room 434 (workshops only)

How to Effectively Manage and Govern Your Power Platform Service

Daniel Christian

YouTuber | MVP |MCT | Solutions Architect

In this workshop you will learn how to effectively manage and govern your Power Platform environment with a focus on maintaining control, ensuring compliance, and optimizing resources. This session will cover:

1. Controlling and Monitoring Copilot: Learn best practices for governing AI capabilities like Copilot, ensuring responsible use while enhancing productivity.
2. License and Capacity Management: Understand how to track and allocate licenses, monitor usage, and optimize capacity to meet organizational needs.
3. App and Workflow Creation Control: Explore strategies for managing app and workflow development, enforcing governance policies, and empowering users within boundaries.

This workshop is perfect for administrators, governance leaders, and IT professionals looking to maintain a well-managed and secure Power Platform environment.