Monday 9:00 AM - 5:00 PM · Room 201
Power Apps and Power Automate (Flow) for M365/SharePoint Bootcamp
![Wes Preston](https://sessionize.com/image/e8f8-400o400o1-az4w2NeSisiqNnCpJREPRp.jpg)
Wes Preston
Founder and independent consultant working with platform alignment and no-code solutions with M365 and Power Apps
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
![Prashant G Bhoyar](https://sessionize.com/image/e5c6-400o400o1-srMo884adG4GG4ioVKDfVS.png)
Prashant G Bhoyar
Microsoft AI MVP, Microsoft Business Applications MVP, MCT, Cloud Solution 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 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 - 5:00 PM · Room 201
Power Automate Multi-Stage Approval Workflows - Workshop
In every organization there are a number of scenarios which require an Approval process. It could be Contract approvals, PTO/Leave Approvals, Event approvals and many other business processes.
In this workshop we'll learn how to design and develop Multi-Stage Approval Workflows using Power Automate. The workflow will move back and forth b/w different stages and will also learn how to restart a workflow from a given stage. We'll learn how to include Dynamic Approvers in the workflow process.
We'll also learn how to design and develop Automated escalations and Automated reminders. We'll implement timeout features in the workflows to escalate it to the next approver in the process. We will learn how to log and retain workflow history beyond what Microsoft Power Automate offers out-of-box. We'll develop a button to kick off the workflow from a SharePoint library/list.
Tuesday 9:00 AM - 5:00 PM · Room 204AB
The One Copilot Workshop to Rule them All
Let's face it, Copilot is everywhere, in everything, it's like the force... and sometimes just as confusing and hard to grasp. Those who learn to harness the power of Copilots within their organization will be able to go where no organization has gone before...
But what does it all mean? It all seems so overwhelming. What if your organization is unwilling to pay for Copilot licenses? What is the average person to do??
Join Mark Rackley in this full-day demo-filled tutorial where attendees will learn:
- What is Copilot and Generative AI?
- What do you need to do to prepare for Microsoft Copilot?
- What are your options for extending Microsoft Copilot?
- When and how should you use Copilot Studio?
- How can you create your own Custom Copilot that doesn't require expensive licensing?
With practical demos and real-world stories from the trenches, you will leave with all of your Copilot questions answered and feeling empowered to embrace Generative AI in your organization.
Tuesday 9:00 AM - 12:30 PM · Room 208AB
Half-Day Workshop : Copilot Studio 101
![Prashant G Bhoyar](https://sessionize.com/image/e5c6-400o400o1-srMo884adG4GG4ioVKDfVS.png)
Prashant G Bhoyar
Microsoft AI MVP, Microsoft Business Applications MVP, MCT, Cloud Solution Architect at AIS
With ChatGPT, other large language models and generative AI have caught the attention of global consumers, enterprises, and c-suite. Microsoft's CEO Satya Nadella Says Microsoft is THE Copilot company. With the adoption of Copilots increasing at a rapid space, there is an exponential rise in the demand for custom copilots.
Microsoft Copilot Studio lets you create powerful AI-powered copilots for a range of requests—from providing simple answers to common questions to resolving issues requiring complex conversations. Engage with customers and employees in multiple languages across websites, mobile apps, Facebook, Microsoft Teams, or any channel supported by the Azure Bot Framework.
In this demo-driven workshop, we will cover how organizations can use the new Microsoft Copilot Studio, ChatGPT, and Azure OpenAI services to build next-gen sophisticated enterprise-grade Copilots.
We will cover:
- Microsoft Copilot Studio Key Concepts
- Azure OpenAI Key Concepts
- ChatGPT key concepts
- How can fusion teams take advantage of Azure Open AI, ChatGPT, and Microsoft Copilot Studio?
- Authentication in Microsoft Copilot Studio
- Power Platform Custom Connectors
- Best Practices
- How organizations can use the new Microsoft Copilot Studio, ChatGPT, and Azure Open AI services to build next-gen sophisticated enterprise-grade Copilots?
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 202A
Power Automate for the Absolute Beginner
If you have been wanting to get started creating Cloud Flows with Power Automate, this is your chance!
In this session, you'll learn:
- What can be done with Flows
- Copilot integration with Power Automate
- 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 11:40 AM - 12:50 PM · Room 201
Boosting Team Efficiency: Easy Automation with Teams Workflows
Dive into the world of effortless automation as we explore how Microsoft Power Automate and Teams can transform your daily grind into a breeze. This session is about cutting the manual work and boosting efficiency, making it perfect for anyone looking to streamline their team's workflow. You will see real-life examples of how integrating Power Automate flows into Teams can automate the mundane tasks we all dread, like scheduling meetings, managing approvals, and even keeping track of project updates—all within the familiar space of your Teams channels.
Learn how to spot opportunities for automation in your day-to-day tasks, customize flows that fit your team's needs, and keep everything running smoothly. By the end of this session, you'll be armed with the know-how to make your team more connected and productive without breaking a sweat. Whether you're new to automation or looking to level up your Teams game, this presentation will show you the fun in functionality with Power Automate and Teams.
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 2:20 PM - 3:30 PM · Room 207A
Power Automate Desktop: How to Automate Almost Anything
Power Automate flows can do a lot to automate repetitive tasks. But up until now they only worked if there was a pre-built connector with actions that can accomplish the task or at least an existing Application Programming Interface API that you could use to build a custom connector.
In this talk we'll look at Power Automate's entry into the world of Robotic Process Automation (RPA) called Power Automate Desktop. Using Power Automate Desktop you can automate repetitive tasks on your desktop in Windows or a Web application. Desktop flows record and play back user interface actions, like keyboard entries, mouse clicks, etc.
Desktop flows open up possibilities to automate applications that don't have a pre-built connector or an API.
Wednesday 4:20 PM - 5:30 PM · Room 201
Navigating Document Approval in SharePoint: A Practical Case Study
At her medical research non-profit, different departments rely heavily on SOP documents, or Standard Operating Procedures. These documents have to go through annual reviews that are several layers deep, in addition to needing a group approval of the final SOP.
In this session, Lindsay will break down exactly how she built SOP approval processes for four different departments using just SharePoint document libraries, Power Automate, and Approvals that have served their purpose effectively and efficiently for years.
Thursday 9:00 AM - 10:10 AM · Room 204C
Empowering Collaboration and Productivity with Microsoft Loop
Microsoft Loop has truly redefined team collaboration and task management in Microsoft 365. This presentation showcases the innovative features of Loop, emphasizing the ability make the most of tasks within its fluid workspaces and canvases, using integration with Microsoft 365 tools like Teams, Outlook and OneNote. This platform not only facilitates real-time collaboration but also enhances task tracking and process management for improved productivity.
Learn effective methods to utilize Loop for organizing tasks, streamlining workflows, and fostering a collaborative environment that adapts to the needs of modern teams. This session provides actionable insights on utilizing Microsoft Loop to elevate team efficiency and drive forward organizational goals.
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 10:40 AM - 11:50 AM · Room 207B
Power Automate for SharePoint
Did you know that the SharePoint Get Items action returns only 100 items by default? If not, attend this session!
In this session, we will dive into the triggers and actions available for SharePoint in Power Automate. You'll see practical examples of how to use Power Automate with SharePoint lists and libraries. Most importantly, we'll discuss common mistakes made by Power Automate developers when interacting with SharePoint as well as best practices.
Avoid many of the "gotchas" experienced by many Power Automate developers when writing Flows for SharePoint by attending this session!
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
![Prashant G Bhoyar](https://sessionize.com/image/e5c6-400o400o1-srMo884adG4GG4ioVKDfVS.png)
Prashant G Bhoyar
Microsoft AI MVP, Microsoft Business Applications MVP, MCT, Cloud Solution 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 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?
Thursday 2:30 PM - 3:40 PM · Room 208AB
Using Power Automate to streamline Microsoft SharePoint archiving at scale & protect long-term data
Learn how Microsoft retention labels & Power Automate can be leveraged to standardize and automate archival transfer processes at scale and why maintaining the readability & integrity of long-term (7+ years) SharePoint data requires more than just regular archiving or cloud storage.
The session will include demonstrations of Power Automate workflows and the automatic application of Microsoft retention labels and explore the risks and challenges of keeping critical data over decades.
Identify if your organization has a technology and compliance gap when it comes to managing long-term SharePoint data and how new embedded archiving solutions - that are a seamless part of the Microsoft 365 and SharePoint experience – can enable you to further leverage your investment in Microsoft tools and applications.
Thursday 4:20 PM - 5:30 PM · Room 203AB
Building Dynamic Websites: Leveraging Liquid and JavaScript in Power Pages
Beyond the drag-and-drop capabilities of Power Pages, empowering to build truly dynamic and interactive websites using Liquid, a templating language, and JavaScript, a powerful scripting language, to unlock advanced functionalities.
Thursday 4:20 PM - 5:30 PM · Room 204AB
Build smarter automation with AI Builder
Embed AI capabilities in your Power Automate flows.
Join us in this session and learn how to integrate AI capabilities in your Power Automate flows as we demonstrate how AI Builder can help you and your organization save time and money by augmenting simple flows with Artificial Intelligence.
In this session we will work with simple use cases, based on real business requirements that all attendee can relate to.
Friday 10:20 AM - 11:30 AM · Room 206
Building Modern Approvals using Microsoft Flow: Advanced Concepts
The introduction of the Approvals Actions in Microsoft Flow 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:
- Building Approval workflows with custom responses without requiring premium licensing
- 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
Friday 12:30 PM - 1:40 PM · Room 206
Power Automate Multi-Stage Approval Workflows
In this session we’ll learn how to design and develop Multi-Stage Approval Workflows Using Power Automate.
We will also learn how to restart the workflow from a given stage and how to include Dynamic Approvers. We'll dig into how to design and develop Automated escalations and Automated reminders. We will also learn how to log workflow history and ways to retain the history indefinitely.
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.
Friday 1:50 PM - 3:00 PM · Room 203AB
Building Intelligent Enterprise-Grade Copilots using Copilot Studio & Azure OpenAI Services
![Prashant G Bhoyar](https://sessionize.com/image/e5c6-400o400o1-srMo884adG4GG4ioVKDfVS.png)
Prashant G Bhoyar
Microsoft AI MVP, Microsoft Business Applications MVP, MCT, Cloud Solution Architect at AIS
With ChatGPT, other large language models and generative AI has caught the attention of global consumers, enterprises, and c-suite. Microsoft's CEO Satya Nadella Says Microsoft is THE Copilot company. With the adoption of Copilots increasing at a rapid space, there is an exponential rise in the demand for custom copilots.
Microsoft Copilot Studio lets you create powerful AI-powered copilots for a range of requests—from providing simple answers to common questions to resolving issues requiring complex conversations. Engage with customers and employees in multiple languages across websites, mobile apps, Facebook, Microsoft Teams, or any channel supported by the Azure Bot Framework.
In this demo-driven session, we will cover how organizations can use the new Microsoft Copilot Studio, ChatGPT, and Azure OpenAI services to build next-gen sophisticated enterprise-grade Copilots.
We will cover:
- Microsoft Copilot Studio Key Concepts
- Azure OpenAI Key Concepts
- ChatGPT key concepts
- How can fusion teams take advantage of Azure Open AI, ChatGPT, and Microsoft Copilot Studio?
- Authentication in Microsoft Copilot Studio
- Power Platform Custom Connectors
- Best Practices
- How organizations can use the new Microsoft Copilot Studio, ChatGPT, and Azure Open AI services to build next-gen sophisticated enterprise-grade Copilots?
Friday 1:50 PM - 3:00 PM · Room 208AB
Real World Power Automate (Cloud Flows)
The Power Automate Community site is a great resource for Power Automate developers. Hundreds of questions are asked and answered on the site every day. These questions are from real Flow developers who experience real world problems.
In this constantly evolving and demo-rich session, our time will be devoted to working through common questions asked and problems encountered by Flow developers and posted on the Power Automate Community site. We will explain the issues and look at each solution in detail. You'll also see how Copilot can help overcome roadblocks that you may encounter during your Flow development.