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

Power Apps and Power Automate Hands-On Quick Start for M365 Makers

Power Apps and Power Automate Hands-On Quick Start for M365 Makers

New to Power Apps and Power Automate? Attend this hands-on workshop to elevate your M365 maker game.

Work through a common business use case from requirements to solution. We'll extend a M365 foundation with Power Apps and Power Automate. Whenever possible, we'll highlight Copilot capabilities offered in both Power Apps and Power Automate. Along the way, you'll receive a solid understanding of the capabilities and features of both technologies.

This is a hands-on session. You walk through clearly defined steps when creating your Power Apps and Flows.

Notes and Requirements: Attendees must come prepared with: A laptop computer (Attendees who bring tablets with keyboards will likely have a sub-optimal experience) A Microsoft 365 (M365) environment where you can create lists, Power Apps, Power Automate Flows, a Team and potentially other Microsoft 365 components If you do not have an M365 environment in which you can work, please consider "purchasing" a Microsoft 365 Business Basic plan currently priced at $6 per month with a 30 day free trial. The subscription can be cancelled within the first 30 days. If you are using a company owned laptop, please verify that you can create Power Apps, Power Automate Flows, a Team as well as other M365 components. Employers frequently lock down laptops.

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

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.

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

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, Flow, or Bot. Copilot can enhance your development experience in multiple ways.

1. 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.
2. Copilot will also help you along the way by suggesting modifications to improve your PowerFX formulas.
3. Copilot controls can also be used in Apps to submit natural language queries about your data
4. You can also embed a Custom Copilot developed in Copilot Studio into your App.

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 9:00 AM - 5:00 PM · Room A404

Mastering Power Automate: From Requirements Gathering to Building Efficient Flows

Dive deep into the transformative capabilities of modern Power Automate with Copilot in this engaging, full-day workshop. Tailored for both newcomers seeking foundational knowledge and seasoned users looking to enhance their expertise, this session will arm you with the critical skills necessary to revolutionize business processes through effective automation. You’ll master the crucial practice of detailed requirements gathering to craft targeted automation strategies, accompanied by practical exercises in designing, building, and deploying powerful flows that boost efficiency and streamline your organizational operations.

By the end of the day, participants will not only possess hands-on skills in flow creation and deployment but will also gain a strategic perspective on utilizing automation to address unique business challenges. This workshop is designed to instill confidence and proficiency, enabling you to leverage Power Automate to its fullest, transforming everyday tasks into automated efficiencies and nurturing a culture of productivity within your team.

Join us to harness the power of automation and reshape your business operations with Power Automate, Copilot, SharePoint, and Microsoft Teams, unlocking new levels of performance and innovation.

Tuesday 9:00 AM - 5:00 PM · Room A313

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 ○ 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

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

From Concept to Creation: Adaptive Cards 101

This workshop will provide a hands on experience for building and deploying adaptive cards. Expect to walk away with with the following skills and knowledge.

-Understand the basic components that go into adaptive cards. -Where to find resources and template to get started. -How to create an adaptive card with actionable items. -Learn how to use power automate to automatically send adaptive card responses. -Understand how to create and manipulate adaptive card Json. -Tips and tricks on good design and formatting.

Walk away from this workshop with the practical knowledge and hands on experience to start using Adaptive cards effectively in your organization.

Wednesday 10:20 AM - 11:30 AM · Room A403

Power Automate 101

Power Automate is a powerful tool, used out of the box with templates or from scratch with your own ideas. Learn the basics of this cloud-based app in this session, with information on what makes a flow, how to enhance a flow with dynamic content, and get some best practices tips so you can start your Power Automate journey off on the right foot.

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

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 11:40 AM - 12:50 PM · Room A410

What's new with Power Apps

Are you overwhelmed with all of the new features that have come out with Power Apps? Me too. So this session we are going to take a practical look at some of the latest announcements and talk about how they apply to your apps. What announcements? I don't know either, I am writing this 6 months before presenting it so who know what is new. 🤣 Good news, it is my job to keep up with the new stuff and have an opinion so I will be ready to rock when the microphone turns on. Should be fun!

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

Demystifying Copilot Studio

Copilot Studio offers the power of bringing Copilots to the masses! Now anyone can create their own Copilot and harness the power of Generative AI! Join this real-word, demo-packed session with Copilot veteran Mark Rackley and discover the truth beyond the marketing including:

• What are the features of Copilot Studio
• How does licensing work?
• How can you extend Copilot for Microsoft 365?
• How do you connect to your business data?
• How to publish your agents to other channels

Wednesday 2:00 PM - 3:10 PM · Room A403

Better Together: Exploring the Integrations Between Microsoft Teams and Power Automate

Get ready to witness the seamless integration of Microsoft Teams and Power Automate! Microsoft Teams stands as an essential tool used daily by millions globally, serving as the cornerstone of modern business collaboration. When paired with the automation capabilities of Power Automate, Teams transcends its conventional role as a communication platform, emerging as a powerhouse for amplifying productivity and efficiency.

During this session, I'll demo a few of the key integration points: • Trigger Flows from Teams Messages: Streamline follow-up actions on a Teams message, with just the click of a button. Whether it’s creating a DevOps item or sending tasks to OneNote, see how Power Automate transforms routine tasks into efficient processes, integrated within the Teams interface. • Flows with Adaptive Cards: Embrace the versatility of Adaptive Cards in Teams to gather information from users. Replace email exchanges with a more intuitive approach to user interaction, directly within Teams messages. • Leverage Flows within the Workflows App: Explore the convenience of creating and managing Power Automate flows directly from the Workflows app embedded in Teams. • Empowerment through Flow Templates: Uncover the potential of pre-built Team and Approval templates, designed to streamline common processes. Foster consistency across your organization and significantly reduce time spent on manual data collection with these readily available automation solutions.

This session promises live demos, real-world use cases, and more.

Wednesday 4:00 PM - 5:10 PM · Room A403

Unleash the Power of Power Automate: Automating Microsoft List Operations

Are you tired of manual and time-consuming data management in Microsoft Lists? Want to streamline your list operations and increase productivity? If so, this session is for you! Join us as we explore the power of Power Automate for Microsoft Lists. We will show you how to move and copy items between lists, including multi-select person and multi-choice values, with ease. Whether you're new to Power Automate or a seasoned user, you will leave this session with the knowledge and skills to automate your Microsoft List operations and take your productivity to the next level. Register now to unleash the power of Power Automate and streamline your Microsoft List operations!

Wednesday 4:00 PM - 5:10 PM · Room A410

Model Driven Power Apps are cool, I will prove it to you!!!

I am aware that there are many other technologies that are considered to be sexier than Model Driven Apps but allow me to show you how cool they can be. When I am done you may have a different opinion about these secure and robust business applications.

When you need to quickly create a robust application that lives on the Dataverse that can handle new and/or legacy data, has access to the Power Platform and has the Microsoft security model look no further.

We will create a new Model Driven App from scratch with new fields, relationships, app theming, security roles and Power Platform components on the fly. Together we will experience just how easy and powerful creating native Model Driven Apps on the Dataverse can be for low-code and pro developers.

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

Introduction to JSON to master customizing SharePoint

JSON is EVERYWHERE in SharePoint Online and your ability to take your SharePoint deployments to the next level depend on your ability to understand and create complicated JSON objects. In this densely demo-packed session, attendees will learn:

• What is JSON and how to understand the structure
• Tips for creating JSON objects and starting with community content as a starting point

Attendees will also learn how to use JSON Objects in SharePoint Online to:

• Customize list columns and list views
• Create Site Designs for creating custom site templates
• Create stunning Quick Views for Viva Connections ACE's
• Post messages in teams as Adaptive Cards
• Process SharePoint REST queries in Power Automate
• and more!!

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

Build a Vacation Request Solution OOB

From gathering requirements to building a workflow in Power Automate, follow along as we build a solution to track and approve vacation requests. Take the information back to your office and build your own vacation request solution. The basis of this simple solution will use out-of-the box functionality in SharePoint and Power Automate.

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

Do more in Microsoft Teams with Power Apps and Power Automate

In today's industry, custom settings and applications are not only in high demand but have become standard practice. To achieve this, the administrator must be capable of building new tools, automating processes, and making it easy for end users to access. This used to be a daunting task that generally meant outsourcing projects, hiring development or hanging a "do not disturb" sign on the already overworked admins' door and hoping for the best months... or years later. Luckily this process has gotten much easier with tools that offer "code-less" or what I like to call nearly code-less automation. This empowers admins to develop tools and automation in minutes and hours, which would have previously taken weeks or longer. And there is very little need to understand deep code. In this session, we will take a look at Power Apps, Adaptive Cards, and Power Automate features that can be leveraged in Microsoft Teams with in Minutes. And yes, there will be live demos to show how easy this can be.

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

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

Thursday 1:00 PM - 2:10 PM · Room A403

Get started with Adaptive Cards for Microsoft Teams using Microsoft Lists and Power Automate

Adaptive Cards are everywhere. They are an incredibly versatile way to create actionable messages in the Microsoft 365 and Power Platform ecosystem.

In this session, we will transform traditional email reminders into interactive, informative, and actionable user experiences using Adaptive Cards. We will showcase Microsoft Lists, Microsoft Teams and Power Automate using a maker approach solution development.

We hope that after this session, you'll want to integrate Adaptive Cards into every solution you build!

Thursday 1:00 PM - 2:10 PM · Room A315

Buttons in SharePoint Lists - Logic for Non-devs

In lists, formatting can be done easily, and buttons can be created using a little JSON code. Wouldn't it be nice for end users to be able to click a button on an item in a list, to set a value or run a flow, without even having to open the item? In this session, you will learn how to create a nice pretty button to quickly click to run a workflow. No menus, no panels, super simple for end users! Laura Rogers will teach you the logic used in order to assign the action that the button takes, how to set up the button's visual appearance, and its text, and how to create conditional formatting on all of these. You will even learn how to utilize Copilot to help with your code!

Thursday 2:20 PM - 3:30 PM · Room A403

Do this, Not that: Power Apps and Power Automate Edition

Join us for an exciting, fast paced session that will guide users through practical dos and don'ts, drawn from real-world solutions. The goal is to showcase some quick flow and app building concepts, in a "Do this, Not that" fashion, but also demonstrate our reasoning behind them.

Key Power Automate topics include:

• Workflow Architecture: Explore parent/child flows for optimized automation.
• Avoiding Hardcoded Values: Utilize filter queries and lookups for dynamic and adaptable workflows.
• Conditional Scenarios: Master controls like condition and switch for intelligent automation.
• Email Formatting: Enhance communication with HTML and/or Markup.
• Copilot: Tips for the best prompts to create and edit flows

Transitioning to Power Apps, we'll cover:

• Triggering Flows: Efficiently trigger flows with a button click for seamless integration.
• Form On Load Rules: Leverage local data by creating collections for enhanced form behavior.
• Branding and Design: Easily incorporate themes for a polished user interface.
• Copilot: Tips for the best prompts to create and edit apps

This session offers a rich experience, filled with tips and tricks inspired by hands-on experience. Whether you're a developer, business analyst, or IT professional, join us to gain practical insights and elevate your proficiency in Power Apps and Power Automate!

Thursday 2:20 PM - 3:30 PM · Room A311

Build an Autonomous Agent with Copilot Studio

Agents are all of the rage, so let's talk about how to build one to take care of your tasks for you. We will show you how we use a Power Automate Cloud Flow to trigger your agent by sending some brief instructions, then let the power of AI take over. Instructions, knowledge, actions, and triggers will all be covered as we teach our agent to do our work for us.

Thursday 4:10 PM - 5:20 PM · Room A410

Model Driven Power Apps are cool: Taking them to the Next Level!!

Now that we know that Model Driven Apps are cool, we are going to take them to the Next Level. This session will focus on building Model Driven apps quickly from a fun set of business requirements. I will jump right into App creation and form design while staying inside the Low Code/No Code box. I will demonstrate how we can get advanced functionality in our Model Driven Apps using the Microsoft provided customizations, Power Automate and maybe a little JavaScript. Along the way we will experience all that Model Driven Apps offer to Low Code/No Code developers and even use Copilot to help when possible.

Thursday 4:10 PM - 5:20 PM · Room A314

Copilot Studio in Action: Elevate ServiceNow with AI Agents

Why navigate to 10 different pages to get what you need when you can use just one ServiceNow agent? Join Lindsay in this session to learn how to build a ServiceNow-oriented Copilot Studio agent. We will start simple - asking questions that Copilot Studio then uses generative AI to crawl ServiceNow KBs and deliver you an answer to, with fallback answer sources able to be configured in Bing custom search.

But that's not enough fun, is it? We'll get into how to then help your user create an incident if they don't find the answer they are looking for, look up the status of their incidents and requests, and even escalate to your Help Desk team, all with the power of Copilot Studio and do-able with a free ServiceNow developer account to get you started.

By the end of this session, you will know the basics of Copilot Studio, using ServiceNow APIs to fetch information both with OOB connectors and custom HTTP calls, and ideas to build your very own tier one Help Desk agent.

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

Planner and Power Platform: Boosting collaboration and visibility

With remote work and an excess of meetings to join every day, it can be hard to find time to sync every task you are working on with your entire team. This can lead to redundant tasks being performed and uneven distribution of work in a team. Finding the right solution to this problem can be time-consuming and fail adoption. The answer is to make it easy and accessible. In this session, we will take a deeper look at how to automate Microsoft Planner with Power Automate, view and modify reporting data with PowerBI, and make this easily accessible in Microsoft Teams.

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

Start to Finish Approach for Governance of Power Platform

There is great popularity in the Power Platform, but with that comes the great responsibility of making sure it’s governed correctly, efficiently and able to scale to all areas of the business. During this session we will cover the aspects to enable business users while complying with business standards.  In this session we will cover themes such as architecture, security, role-based access, monitoring and alerting, and licensing considerations. Understanding where to start can take you to the finish line quicker and easier.

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

Copilot Studio for Power Apps and Automate People

Did you know Copilot Studio is part of the Power Platform? And that it uses a lot of the same connectors, flows, and even Power FX you are used to? 😲 I know! So in this session I am going to show you how your low code skills are a huge advantage when it comes to building agents.

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

Navigating Document Approval in SharePoint: A Practical Case Study

At a 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 six different departments using just SharePoint document libraries, Power Automate, and Approvals that have served their purpose effectively and efficiently for years.

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

Discover the Full Potential of Microsoft Lists with Power Platform

Microsoft Lists, a core component of Microsoft 365, has been significantly enhanced through its integration with the Power Platform. In this session, we will examine three fundamental features of the Power Platform embedded within Microsoft Lists. Together, we'll explore the baked in options for the following:

Power Apps: Form Options Comparison

• Create an App: Build a canvas app directly connected to a List
• Customize Forms: Integrate Power Apps into a native List form

Power Automate: Streamline Processes with Pre-built Flows

• Content Approval: Navigate page approval processes effortlessly.
• Request Sign-off: Simplify decision-making with streamlined audit trail
• Reminder Options: Specify a date for task follow-ups

Power BI: Unlocking Insights from Data

• Visualize Lists: Quickly transform data into compelling visual narrative
• Microsoft List as a Data Source: Create refreshable reports connected directly to List data

Live demos throughout the session will illustrate practical implementations of these tools. Additionally, we'll address the pivotal question of when organizations may outgrow integrated options, along with essential licensing considerations for scaling up to advanced solutions.

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

Revolutionizing SharePoint Workflows with Power Automate and Copilot

In today’s fast-paced digital workplace, efficiency and automation are key to staying ahead. Join us for an exciting session where we delve into the transformative power of integrating Microsoft Copilot with SharePoint and Power Automate. Discover how Copilot’s AI capabilities can revolutionize your workflows, turning complex processes into seamless, automated tasks.

We’ll explore real-world scenarios where Copilot enhances SharePoint workflows, from automating routine approvals to managing intricate data processes. Learn how to harness the full potential of Power Automate to create intelligent, responsive workflows that adapt to your organization’s needs.

This session will feature live demonstrations, showcasing step-by-step how to build and deploy these advanced workflows. You’ll walk away with practical knowledge, best practices, and innovative ideas to implement in your own environment. Whether you’re a seasoned pro or just starting out, this session will provide valuable insights to elevate your SharePoint and Power Automate skills to the next level.

Key Takeaways:

Understand the integration of Copilot with SharePoint and Power Automate. Learn to create intelligent workflows that enhance efficiency and reduce manual tasks. Gain insights from real-world examples and live demonstrations. Discover best practices for implementing advanced automation in your organization. Join us to unlock the future of workflow automation and see how Copilot can be your co-pilot in driving productivity and innovation!

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

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.

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

No Code Deep Impact: Advanced Column types, Business Rules & Business Process Flows in Power Apps

If you are looking for No Code ways to have a Deep Impact on your Power App development, then you are in the right place. In this session we will discuss and demonstrate how different Advanced Column (field) types, Business Rules and Business Process Flows can have a profound effect on the functionality of your Power Apps. These No Code customizations can add great value to a Power App when use separately or together. This session will demonstrate how to use these different customizations together to build a powerful solution.

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

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 A410

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 1:50 PM - 3:00 PM · Room A311

Be Your Own Copilot: How to Create your Own Generative AI Assistant

Copilot... it's EVERYWHERE. Copilot and Agents promise to make your work life better, give you more hours in your day, and generally revolutionize the world. That being said, maybe you don't have a Copilot license? Maybe you need to go beyond ChatGPT to actually have an Agent perform tasks for you. How can the YOU harness the power of Generative AI to make YOUR job easier, to automate YOUR processes, and find real world uses for Generative AI. Go beyond the hype and join this demo-packed session as Mark Rackley walks you through real world examples of how to leverage Azure OpenAI today to create custom Copilots without needing a Copilot license or worrying about your data leaving your tenant.