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

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

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

We'll start with some brief foundation info, 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.

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.

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

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 may choose to use a personally owned or corporate Microsoft 365 tenant. If not, please register for a free Microsoft 365 Developer tenant prior to the workshop here: https://developer.microsoft.com/en-us/microsoft-365/dev-program

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 7

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 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 • Afternoon: Power Automate ○ Using Conditions and Switches effectively ○ Handling Loops and Parallel Branches ○ Working with Large Data Sources ○ Implementing Error Checking/Correction ○ Improving Performance

Tuesday 9:00 AM - 12:30 PM · Room 7

Copilot for Power Platform : Accelerating your Development with AI

Microsoft is adding AI support to the Power Platform low code development platforms called Copilot. You can use Copilot to help build your next App or Flow. Using Copilot you can use natural language to describe what you are trying to build. Copilot will return a suggested design for the app, flow, or Dataverse tables which you can then use. Copilot will also help you along the way by suggesting modifications to improve your formulas.

Copilot won't replace you as a Citizen Developer, but it will help you produce amazing apps and powerful flows in a fraction of the time.

Tuesday 1:30 PM - 5:00 PM · Room 6

SharePoint Data Modeling: From Requirements to Usage

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.

Wednesday 11:40 AM - 12:50 PM · Room B

Using PowerApps and Flow Together: Made for each other

PowerApps and Flow 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 PowerApp, how to pass information to the Flow, and how to return values back to Powerapps when the Flow completes. Along the way we'll discuss Best Practices that can make your PowerApps and Flow work more efficiently togethter. Even if you know both PowerApps and Flow this session will help you get the most out of using them together.

Wednesday 2:20 PM - 3:30 PM · Room 2

Offline Apps Unplugged: Balancing Benefits and Drawbacks in a Connected World!

Join Daniel Christian, a Microsoft MVP and certified trainer for an insightful session where he dives into the intricacies of configuring Power Apps for offline use. He will guide you through the step-by-step process of setting up offline capabilities in Power Apps, ensuring your applications remain functional and efficient even without an internet connection. Additionally, he will address the potential drawbacks, including data synchronization challenges, increased complexity in deciding which backend data source to use, and potential limitations in real-time data updates.

Wednesday 4:20 PM - 5:30 PM · Room D

10 new features in Power Apps everyone should know

This 60-minute session, delve into the dynamic world of Power Apps as we unveil the top 10 new features transforming the landscape of app development. With the ever-evolving demands of modern businesses, Microsoft's Power Apps continues to evolve, empowering users to create custom applications with unprecedented ease and efficiency. From enhanced data integration capabilities to advanced automation features, this session will provide a comprehensive overview of the latest innovations in Power Apps. Through live demonstrations, practical examples, and expert insights, attendees will gain valuable insights into harnessing the full potential of Power Apps to streamline processes, boost productivity, and drive digital transformation within their organizations. Whether you're a seasoned Power Apps user or just beginning your journey, join us to discover the game-changing features shaping the future of app development.

Thursday 9:00 AM - 10:10 AM · Room 7

Drive your digital transformation with the Power Platform

Join us in this session to learn how to create applications, automate business processes and monitor your organization’s performances using Power Apps, Power Automate and Power BI. We will perform a step-by-step demo showing how to create a mobile application, an approval flow and a Dashboard to track requests from a SharePoint list. In this session, we will work with a simple use case, based on real business requirements that all attendees can relate to.

Thursday 10:50 AM - 12:00 PM · Room 7

Power Apps Evolution of Efficiency: 10 Methods That Have Transformed Over Time

In recent years, the Power Apps canvas app landscape has experienced a rapid evolution, characterized by the constant release of innovative features and tools. This continuous stream of advancements has inevitably changed the way you approach app development. Join Daniel Christian, a Microsoft MVP and certified trainer and he walks you through 10 methods of his app development that have transformed over time. This includes database planning, app designing, building and permissions management and how to make it all easier using Copilot.

Thursday 1:30 PM - 2:40 PM · Room D

Forms, Forms, and more Forms. Data gathering for the modern info worker

Microsoft List (and SharePoint) forms, Forms with Power Apps, and Microsoft Forms. Which one (or more) should you use, and when?

This session will walk through updated capabilities and options available to no-code makers and citizen developers when building solutions with forms.

Thursday 3:30 PM - 4:40 PM · Room 6

Hyperautomation in Procure-to-Pay: Revolutionizing Efficiency with AI Builder and Azure

In the digital age, hyperautomation has become a pivotal force in transforming business processes, and the procure-to-pay cycle is no exception. This session will guide you through the significance of hyperautomation in the procure-to-pay process, demonstrating how it not only streamlines operations but also serves as a strategic asset in enhancing financial health and operational agility.

Key Takeaways: Gain insights into the four-step process of the procure-to-pay cycle and the role of hyper automation in integrating purchasing and accounts payable systems for peak efficiency.

Understand how AI Builder and Azure are revolutionizing the procure-to-pay landscape by automating manual tasks, improving invoice processing, and ensuring data accuracy.

Explore real-world examples of hyper automation in action, showcasing the tangible benefits of reduced processing times, increased margins, and enhanced decision-making capabilities.

Session Highlights:

AI Builder's Role: Delve into how AI Builder brings Microsoft's cognitive and AI offerings to life, enabling users to create and consume AI with ease, thus optimizing business processes within the procure-to-pay cycle.

Azure's Impact: Discover the transformative potential of Azure AI, including tools that ensure secure and trustworthy generative AI applications, and how they contribute to a more efficient procure-to-pay process.

Customer Success Stories: Learn from successful implementations of hyper automation, such as the integration of Power Automate, Model-driven Apps, and Dataverse with AI Builder and Azure AI services, resulting in streamlined operations and improved financial outcomes.

This session is designed for finance professionals, procurement specialists, and technology enthusiasts looking to harness the power of AI and hyper automation to drive their organization's success. Join us to explore how AI Builder and Azure can be your allies in the journey towards a smarter, more efficient procure-to-pay process.

Friday 9:00 AM - 10:10 AM · Room 2

Create Adaptative Cards with Power Apps

Power Apps cards are micro-apps with enterprise data and workflows and interactive, lightweight UI elements that other applications can use as content. Because they're part of the Power Apps ecosystem, cards can add business logic through Power Fx and integration with business data through Power Platform connectors. Using cards, you can quickly build and share rich, actionable apps without any coding or IT expertise.

Join us in this session to get started with Card in Power Apps. We will take a tour of the Power App Card Designer, go over the controls it has to offer, connect to different data sources and send a Card to a Teams channel.

Friday 10:20 AM - 11:30 AM · Room A

Two Guys and A Copilot - The DnA Show!

Daniel and Andy (DnA) are two guys who work for enterprise level companies and must deal with day-to-day tasks that can be both time consuming and mundane. However, now with Copilot available across several Microsoft cloud services, these two Microsoft MVPs are finding ways to making their jobs a lot easier and, in some cases, automated.

So, join them as these two guys show share their tips and tricks with you to make your jobs easier and make you look like Copilot superstars. This session will cover both Power Platform and Microsoft 365 Copilot features.

Friday 10:20 AM - 11:30 AM · Room 7

Build a FHIR based Healthcare App on Power Platform

FHIRlink Connector is a first-party connector enabling makers to build Power Apps and Flows that connect directly to a healthcare organization's FHIR services.  This reduces the need for complex data synchronization services.

Friday 12:30 PM - 1:40 PM · Room 2

Intro to Dataverse for M365 Makers

Dataverse, Dataverse, Dataverse… You've been hearing about it for a while but haven't checked it out yet. Now's the time. Adding Dataverse is an investment in time, skills, and licensing. Know when to engage and what to expect.

• Learn what Dataverse is and where it fits in the maker toolset.
• Cover what the differences are between Dataverse, Microsoft Lists, and other data sources and talk through some of the 'what to use when' considerations as Lists solution builders integrate with and shift to Power Platform tools.
• Get a perspective on the maker skills needed when using Dataverse and how to get started in your organization.

Friday 1:50 PM - 3:00 PM · Room 2

Deploying Power Platform Components: Using Solutions

If you work with more than one application from the Power Platform or have more than one environment then you've probably heard about Solutions. But Solutions can be a confusing concept for citizen developers. In this workshop we'll discuss the following concepts:

• Implementing a Dev > Test > Production system
• Exporting and Importing Apps, Flows, and Bots between environments
• When to use Managed vs. Unmanged Solutions
• Creating, Updating, Upgrading, and Patching Solutions
• Using Connection References
• Leveraging Environment Variables
• What is a Solution Publisher
• Understanding Solution layers and dependencies

Friday 1:50 PM - 3:00 PM · Room 5

Exploring Power Platform AI for Next-Generation Solutions

In the era of digital transformation, organizations are increasingly turning to artificial intelligence (AI) to drive innovation, streamline operations, and deliver unparalleled experiences to customers and employees alike. Microsoft Power Platform AI emerges as a game-changing toolkit, empowering citizen developers and IT professionals to harness the power of AI and build intelligent solutions without the need for extensive coding expertise.

This session invites you to embark on a journey into the world of Power Platform AI, where imagination meets innovation to unlock new possibilities and drive business growth.

Attendees will dive deep into the capabilities and functionalities of Power Platform AI, in:

• PowerPlatform
• Power Automate
• DataVerse
• Power Pages
• Power Virtual Agent (CoPilot)

Through hands-on demos, real-world use cases, and best practices, attendees will learn how Power Platform AI is transforming industries and driving innovation across diverse business domains, including sales, marketing, finance, and customer service.

Join me as we explore the limitless possibilities of Power Platform AI and discover how you can empower your organization to innovate, automate, and thrive in the AI-powered future.