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

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 202A

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

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

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

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

With ChatGPT, other large language models and generative AI has caught the attention of global consumers, enterprises, and c-suite. In this demo-driven workshop, we will cover how organizations can use Azure OpenAI and Power Platform services to implement next-gen sophisticated enterprise-grade business applications.

In this demo-driven workshop, Microsoft Business Applications and AI MVP and Microsoft Certified Trainer Prashant G Bhoyar will cover how to use Azure OpenAI services and ChatGPT with services like Power Apps, Copilot Studio, Power Automate, Power Pages, and Power BI.

We will cover: • Azure OpenAI Key Concepts • ChatGPT key concepts • How can fusion teams take advantage of Azure OpenAI, ChatGPT, and Microsoft Power Platform? • Authentication and Authorization in Azure • Azure OpenAI + Power Automate • Azure OpenAI + Power Apps • Azure OpenAI + Power Pages • Azure OpenAI + Copilot Studio • Azure OpenAI + Power BI • ChatGPT and Power Platform • Azure API Management • Power Platform Custom Connectors • How organizations can use Azure Open AI and Power Platform services to implement next-gen sophisticated enterprise-grade business applications? • How to evaluate the use cases for Custom Copilots?

At the end of the workshop, attendees will have a working knowledge of Azure OpenAI, ChatGPT, 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, Safari. The tablets will not work.

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

Dataverse Bootcamp 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.

Using the Developer Plan, attendees will get a hands-on look at Creating Dataverse tables, relationships, forms, and more. With Dataverse as a data source, we'll also do a quick compare of model-driven vs. canvas Power Apps.

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

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 9:50 AM - 11:00 AM · Room 207A

Super Charge your Power Apps and Copilots with Power Fx

Power Fx is the low-code language that can be used across the Microsoft Power Platform. It's a general-purpose, strong-typed, declarative, and functional programming language. Citizen developers and Professional developers can use it to build business applications.

In this demo-drive session, we will cover the following topics in detail.

• What is Power Fx?
• What are Data Types?
• What are Operators and identifiers, Tables, Variables, Imperative logic, and Global support?
• How can we use Power Fx in Power Platform to build the business application?
• Power Fx Best Practices

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

Intro to Power Apps for Microsoft Teams, SharePoint, and Lists

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 canvas 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 and set the stage for further enhancements

Wednesday 11:40 AM - 12:50 PM · Room 204AB

Healthcare Virtual Data Tables

Healthcare Virtual Data Tables (HVDT) is Microsoft's solution for connecting Dataverse to remote FHIR endpoints using Dataverse's Virtual Tables capabilities. Our solution extends Dataverse Virtual Tables by providing configurable mapping between FHIR and Dataverse schemas and allows customers to dynamically select where you want to persist your data.

This session includes an architectural overview of the solution, a demonstration of HVDT connecting to Azure Healt Data services, and a demo of how we can extend the data model and maps.

Wednesday 11:40 AM - 12:50 PM · Room 207A

How to Execute JavaScript, TypeScript, and Excel Formulas In Power Automate

Power Automate has become an essential tool for the Microsoft 365 developer. However, all too often executing simple logic can become tedious and painful using Power Automate standard features. Doing math in Power Automate shouldn't be so painful!

Thankfully, Power Automate developers can now create scripts that use JavaScript, TypeScript, or even Excel formulas to execute complicated business logic and bring more power to your Power Automate solutions. Attend this demo-packed session to learn out to take your Power Automate Flows to the next level as we dive into a real-world scenario and build a practical solution step-by-step.

In this session, attendees will learn to use Office Scripts to:

• Execute JavaScript, TypeScript, and Excel Formulas
• Simplify complicated Flows
• How to quickly and easily generate dynamic adaptive cards
• Generate graphs and charts on the fly for real-time updates to SharePoint data

Wednesday 4:20 PM - 5:30 PM · Room 202A

To Build or Buy: Case Management in Dynamics 365 or Power Apps

It's an age-old question: should I buy the solution "off the shelf" or build it myself? In the past, the high cost of custom development meant most people bought their software and did their best to "make it work."

But with the advent of low code, more and more organizations are not having to make that choice, but inside discovering it's really a spectrum.

This session will look the specific need many of my customers have: case management. In the past and sadly in the present, many of my customers rely on Excel to manage cases (or incidents or whatever terminology they use). Thanks to Power Apps, these customers have a better way.

But what about Dynamics 365? When should they consider it versus a "home grown" solution. I'll look at the pros and cons of both approaches and perhaps help you find the "sweet spot."

Thursday 10:40 AM - 11:50 AM · Room 207A

Simplify Reporting: Automating Document Generation with Power Apps and Power Automate

In this session, we will explore how to modernize the common process of weekly reporting by automating document creation using Microsoft Power Apps and Power Automate. We will follow a real-life use case of a client who aimed to streamline their cumbersome, manual reporting process.

We will demonstrate how Power Apps and Power Automate were used to improve this process:

• Standardized Data Entry with Power Apps: We'll show an example of a user-friendly submission app in Power Apps, standardizing the input format and eliminating the need for multiple templates.

• Workflows with Power Automate: We’ll create workflows in Power Automate that: Collect and format submissions from the app Consolidate submissions into a single report template Generate a report in multiple formats (docx, pdf, and xlsx)

• Document Storage in SharePoint Online: We’ll show how the workflow can save the generated reports to support further manual editing

By automating their weekly reporting process, the client was able to save hours of manual work while improving accuracy and consistency across reports.

Thursday 12:30 PM - 1:00 PM · Room 206

Microsoft PowerApps and Facilitating 508 Compliance

Best practices and lessons learned in applying 508 Compliant requirements to applications developed using the Microsoft PowerApps platform.

Thursday 1:10 PM - 2:20 PM · Room 202B

Dataverse Virtual Tables - Build a Custom Provider

Dataverse Virtual Tables is a platform capability allowing Model Driven App developers to provide a unified experience for multiple sources of data. This means that some of your data may reside in the Dataverse database while some may reside in external data sources.

The Virtual Tables solution ships with out of the box providers, but what if these providers don't quite fit your current solution requirements? We can build our own custom data provider for Virtual Tables that surfaces data from an external data source.

This session will provide a quick walk through of requirements dive right into building our own custom data provider for Virtual Tables. We review code behind the plugin events for Retrieve and Retrieve Multiple, demonstrate how to transform your data, and see the plugin surface data live in our Model Driven App.

Thursday 1:10 PM - 2:20 PM · Room 204AB

Modernizing Paper Form Processing with Power Platform and AI

In this session, we delve into the transformational journey of a large government agency’s office. Their cumbersome process of handling hundreds of paper forms submitted by employees each month was riddled with inefficiencies and prone to errors. Enter the Power Platform and AI—a dynamic duo that revolutionized their operations.

Challenges Faced ---------

• Time-Consuming Workflow: Manual data entry from legacy paper forms consumed valuable hours.
• Error-Prone Process: Human errors led to inaccuracies and delays.
• Lack of Efficiency: The existing system hindered productivity and citizen satisfaction.

Our Solution ---------

Power Platform Unleashed:

• Power Apps: We built a user-friendly front-end citizen portal, replacing a paper form
• Power Automate: Automated data extraction from scanned forms using AI. Power Pages: Streamlined collaboration and reporting.
• AI-Powered Data Extraction: Leveraging Azure Open AI and Microsoft Copilot Studio, we extracted relevant data swiftly and accurately. Citizens’ information seamlessly flowed into the system, reducing manual effort.
• Secure Data Collection: The new citizen portal ensures safe and confidential data submission. Data is directly imported into Dynamics 365 Case Management for streamlined case handling.

Key Takeaways --------------

Learn how to modernize processes using the Power Platform. Understand the role of AI in data extraction and accuracy. Witness the transition from paper forms to a secure digital interface.

Join us to explore the intersection of technology, efficiency, and citizen-centric services. Let’s empower agencies to serve their communities better!

Thursday 1:10 PM - 2:20 PM · Room 207B

Using Power Apps and Power Automate 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 Flows work more efficiently together.

Even if you know both PowerApps and Power Automate this session will help you get the most out of using them together.

Thursday 2:30 PM - 3:40 PM · Room 204AB

Azure For Power Platform Developers

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 demo-driven session, 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:

• How does Power Platform use Azure?
• How can fusion teams take advantage of Microsoft Azure and Microsoft Power Platform?
• Authentication and Authorization in Azure
• How to create an enterprise-grade app using Azure and Microsoft Power Platform?

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

Cast votes with confidence: Crafting a reusable Power Apps canvas app voting solution

Learn how to create a versatile and reusable voting app with Power Apps, perfect for a wide array of scenarios. From education institutions hosting student elections to photo or costume contests to organizations recognizing standout employees—this session will unveil how to harness SharePoint integration for a seamless voting experience.

You'll learn how to:

• Design a user-friendly interface for collecting votes.
• Configure a SharePoint document library to store contest entries or nominations.
• Set up a SharePoint list to track and tally votes securely.
• Implement logic to ensure fair voting and prevent duplicate entries.
• Add a touch of flair to your voting experience with custom branding and design elements.

Embrace the potential to elevate engagement in your organization. Walk away with the knowledge to implement a voting system that resonates with elegance and efficiency, year after year.

Friday 9:00 AM - 10:10 AM · Room 202B

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.

Friday 9:00 AM - 10:10 AM · Room 203AB

PowerFx Command Buttons in Action

Join me as we delve into the simplicity and flexibility of creating custom confirmation dialogs, duplicating records, and carrying out bulk updates with enhanced safety measures, all with Power Fx.

This session is perfect for those looking to streamline their Dynamics workflows and for professionals eager to leverage their Dynamics 365 platform to its fullest extent with minimal coding requirements.

Key highlights of this interactive session will include:

• Building user-friendly custom confirmation dialogs to improve user interactions and data input accuracy.
• Efficiently cloning records to streamline data management processes to save time and reduce data entry errors.
• Allow bulk update in a safe way, limiting the chances of mistypes wreaking havoc on your system.
• Integrating Power Automate flows to make Command Buttons much more powerful.
• Show in-app notifications to your users.

Friday 1:50 PM - 3:00 PM · Room 202B

Real World Solutions Built with Microsoft 365

Microsoft 365 is a powerful platform that can empower business users to create their own solutions to more effectively handle daily business processes. This session is designed to showcase the capabilities of Microsoft 365 to inspire you to start building your own custom business solutions.

In this session, we'll explore real world solutions to demonstrate the capabilities of Microsoft 365 and inspire you to build your own.

A few solutions we'll discuss: Using SharePoint and Teams to build collaboration spaces for getting work done and publishing portals for sharing and distributing information.

SharePoint hub sites and homes sites for organizing and future proofing your workspaces and portals complete with navigation, access controls, branding, and more.

SharePoint News for news, announcements, and updates to keep your teammates up-to-date.

Microsoft Lists and Power Automate for simple and powerful approval, tracking, and publishing processes.

Planner for central task management with your team.

Viva Engage communities for enterprise information sharing such as frequently asked questions, weekly tips & tricks, town halls, and executive communications.

Stream for creating, editing, and sharing video across Teams, OneDrive, SharePoint, and Viva Engage.

And Microsoft Teams to bring everything together and provide a central gateway for it all.