Washington, D.C.

Power Automate (Flow) / Workflow Track

Monday, June 12th 2023, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCM & MBA

Dataverse for Teams: Extending Teams with Apps, Flows, and Bots

Use of Microsoft Teams has exploded for many companies during the global pandemic. For many organizations Teams has become the app that connects all their employees together. Power Platform apps, like Power Apps, Power Automate, and Power Virtual Agents, provides a low-code platform for extending that functionality. In September, 2020 Microsoft announced Dataverse for Teams. Dataverse for Teams is included in the Teams license so you can build apps, flows, and bots that make use of relational data storage, rich data types, and enterprise-grade governance without additional expense. In this workshop we'll look at how to use Dataverse in the Power Platform to extend the Teams application. By the time you leave you'll have an integrated Teams application and bot that can help your employees manage their presence as people move back into the office after the Pandemic. We'll cover the following with slides and hands-on exercises: - What does the Teams License cover - Differences between Dataverse (CDS) and Dataverse for Teams - Creating Dataverse Relational Tables - Securing Dataverse for Teams Tables - Building a Power App with Dataverse for Teams - Integrating Dataverse for Teams with a Flow - Accessing Dataverse for Teams from a Bot - Managing Dataverse for Teams Environments - Deploying Custom Apps, Bots, and Flows to additional Teams Check out my workshop preview: https://youtu.be/iaNLIczVFNg

Monday, June 12th 2023, 9:00 am

  • William Huneycutt

    Microsoft MVP & MCT

Business Process Automation with Power Apps and Power Automate

Learn how to get started quickly with Power Apps and Power Automate (Flow) in SharePoint Online. Discover how to use built-in connections to connect Power Apps to services such as SharePoint Online, Office 365 apps, and even SharePoint on-premise. Learn how to customize the look and feel of forms and apps to meet the needs of users and apply company branding. Also, learn how to share Power Apps with colleagues without going over budget:  - Customize SharePoint list forms with Power Apps - Create a canvas app based on a SharePoint list - Connect to data sources - Themes, branding, and layouts - Conditional formatting - Rules and data validation - Formula bar This session will also discuss how to get started with Power Automate (Flow). Learn how to take advantage of pre-built templates for creating workflows. Learn how to create custom Flows in an easy-to-use visual designer right in a web browser. Finally, we'll discuss how to manage your Flows during and after runtime: - Connectors, data sources, and gateways - Events vs triggers - SharePoint Designer actions vs Flow actions - Conditions for Flow - Workflow history - Flow connections and ownership - Licensing The future of SharePoint is exciting, and the addition of Power Apps and Power Automate (Flow) can help to address the challenges faced by today’s information workers.

Monday, June 12th 2023, 9:00 am

  • Prashant G Bhoyar

    Microsoft MVP & MCT

Hands-On: Azure For Power Platform Developers Masterclass

In this hands-on workshop, we will cover how to use Azure for custom development in Microsoft Platform, Power Automate, Power Apps, Power Virtual Agents, Dataverse, and Power BI. We will cover: - Microsoft Azure Key Concepts - How does Power Platform use Azure? - How can fusion teams take advantage of Microsoft Azure and Microsoft Power Platform? - Authentication and Authorization in Azure - Azure + Power Automate - Azure + Power Automate - Azure + Power Apps - Azure + Power Virtual Agents - Azure + Power BI - Azure + Dataverse - What are Azure Functions? - What are Logic Apps? - What is Azure Bot Service? - How to create an enterprise-grade app using Azure and Microsoft Power Platform? At the end of the workshop, attendees will have a working knowledge of Azure and how to use it to implement the customizations in the Microsoft Power Platform. Access to Azure, Microsoft Power Platform ( Power Apps, Power Automate, Power Virtual Agents, 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. You Will Learn : 1. Authentication and Authorization in Azure? 2. How does fusion teams can take advantages of Microsoft Azure and Microsoft Power Platform? 3. How to create enterprise grade app using Azure and Microsoft Power Platform

Monday, June 12th 2023, 9:00 am

  • Daniel Christian

    Microsoft MVP & MCT
  • Scott Shearer

    Microsoft MVP & MCT

Power BI For The Absolute Beginner

Have you only heard of Power BI in passing or have always been the end-user but now are ready to learn and invest in this tool to bridge the gap between data and decision making? Then this is a must attend workshop for you. Join Daniel Christian and Scott Shearer who are both Microsoft MVPs and MCTs as they take you on a journey into the Microsoft Power BI world. This full day workshop will first introduce you into the past and present of Power BI and then dive into demos. Daniel and Scott will walk you through how to use commonly used data sources such as Dataverse, SharePoint and SQL to build reports that help visualize your data and create amazing experiences for the end users. They also focus on the deep integration across the Power Platform family i.e. from the report kick-off a Power Automate flow or add a Power Apps canvas app to edit data. In this workshop, you'll be introduced to: • Power BI Licensing • Using the Power BI Desktop App • Using the Power BI Service • How to create reports and dashboards • DAX fundamentals • Integration with Power Apps and Power Automate • Learning resources • And more (time permitting...) Please note that this is not a hands-on workshop but attendees are welcome to follow along.

Tuesday, June 13th 2023, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCM & MBA

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 Check out my workshop preview: https://youtu.be/S1Wjjwv0P50

Tuesday, June 13th 2023, 9:00 am

  • Daniel Christian

    Microsoft MVP & MCT

Microsoft Power Platform in a Day

With the Power Platform having been available for over 6 years, it is now an enterprise level, low code platform to build reports, apps, flows and chatbots. For the first time ever you can build your own solution and make it available for your company users. This skill of building professional low code apps is in such high demand that makers have successfully made a career out of it. Join Daniel Christian, a Microsoft MVP, certified trainer and an early adopter of the Power Platform, as he walks you through how this Power Platform journey began and gives you a technical overview of Power Apps (Canvas and Model-Driven), Power Automate, Power BI and Power Virtual Agents. This workshop will comprise of several walk-through demos, stories with examples and even an interview with a surprise guest. Here is an overview of the workshop: - Power Apps + Canvas + Model-Driven + Portal - Power Automate + Flows + Robotic Process Automation - Power BI - Power Virtual Agents - Dataverse - Integration with Microsoft Teams - Cross platform integration - Soon to arrive features! So if you are someone who has heard about Power Platform and would like to get a better technical understanding on what the services have to offer, then you do not want to miss this workshop! Check out my workshop preview: https://youtu.be/DhArVJvKZVc

Tuesday, June 13th 2023, 9:00 am

  • Prashant G Bhoyar

    Microsoft MVP & MCT

Power Platform Governance 101

In this half-day workshop, we will cover the key principles of Power Platform Governance. Effective governance policies play a big role in the successful roll-out of the Power Platform across the organization and running it on a scale. The governance policies will include Power Automate, Power Apps, Power Virtual Agents, Power Pages, Dataverse, and Power BI. In this demo-driven workshop, we will cover, 1. Power Platform Governance Overview 2. Center of Excellence ( CoE ) Starter Kit 3. Automation Kit 4. Data Loss Prevention policies 5. User Management 6. Permission manager 7. License and capacity management 8. Security and Control 9. Managed Environments 10. Best Practices

Tuesday, June 13th 2023, 1:30 pm

  • Scott Shearer

    Microsoft MVP & MCT
  • Wes Preston

    Microsoft MVP

Power Automate for SharePoint Bootcamp

We will start the afternoon with an overview of Power Automate. You'll learn about the different types of Flows that can be created with Power Automate and will start creating Flows yourself. We'll then dive into Power Automate concepts including expressions, variables and loops. We'll move on to thoroughly covering how to use Power Automate with SharePoint. Finally, we see how to integrate Power Apps and Power Automate. Live demos will be used to demonstrate all of these concepts. You'll have the opportunity to implement what you have learned through a series of hands-on labs. 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, SharePoint, Microsoft Lists, Teams, 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. Check out our workshop preview: https://youtu.be/d8brL7-GDAc

Wednesday, June 14th 2023, 9:50 am

  • Vlad Catrinescu

    Microsoft MVP & MCT

Getting Started with Microsoft Power Automate

The Microsoft Productivity cloud is used by more than 250 million users daily - and is the productivity platform of choice for most enterprises in the world. Microsoft Power Automate, part of the Microsoft Power Platform is a business process automation tool that allows you to streamline and automate business processes. In this session, Getting Started with Microsoft Power Automate, you will learn foundational knowledge of Microsoft Power Automate. First, you will learn the basic terms and concepts of Microsoft Power Automate. Next, you will discover how to create your own cloud flows. Finally, you will learn how to create workflows that integrate with Microsoft Teams.

Wednesday, June 14th 2023, 11:30 am

  • Amarender Peddamalku

    Practice Lead at Perficient

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.

Wednesday, June 14th 2023, 1:40 pm

  • Bobby Chang

    Power Platform Global Black Belt at Microsoft

Automate Your Way with RPA

Let's demystify Robotic Process Automation (RPA)! This session will focus on how to automate legacy web and client applications using Power Automate. We'll demonstrate how to leverage Desktop flow with Power Automate Desktop, and how/when/why you would combine desktop automation with Power Platform connectors and AI to provide end-to-end workflow solutions for your organization.

Wednesday, June 14th 2023, 1:40 pm

  • Paul Papanek Stork

    Microsoft MVP, MCM & MBA

Intro to Microsoft Dataverse for Teams: Extending Microsoft Teams with Apps and Flows

Use of Microsoft Teams has exploded for many companies as a result of the global pandemic. For many organizations Teams has become the app that connects all their employees together. Power Platform apps, like Power Apps, Power Automate, and Power Virtual Agents, provides a low-code platform for extending that functionality. But extending Teams with new apps, flows, and bots requires a place to store content. SharePoint is a possibility, but from a data point of view SharePoint has a lot of limitations since it isn't an actual relational database. Dataverse, formerly known as CDS, provides relational data storage, rich data types, and enterprise-grade governance. But Dataverse has always been a premium feature requiring extra licensing. This is where Microsoft Dataverse for Teams comes in. Using the Power Apps application inside Teams we can build and deploy apps using a custom version of Dataverse that is included in the Microsoft Teams license. This provides access to a real relational database and one-click solution deployment to the Teams app. In this talk we'll take a look at what Dataverse for Teams and how it can be used in the Power Platform to extend the Teams application. We'll cover the following points with slides and demos. - What does the Teams License cover? - Differences between Dataverse (CDS) and Dataverse for Teams - Creating Dataverse Relational Tables - Building a Power App with Dataverse for Teams - Integrating Dataverse for Teams with a Flow - Accessing Dataverse for Teams from a Bot

Thursday, June 15th 2023, 9:00 am

  • Scott Money

    Director of Operations at DocPoint Solutions
  • Stephen Duffy

    Senior Solutions Engineer at DocPoint Solutions

Power Automate – Uploading content to SharePoint from Azure drives

Creating a scheduled, automated process that will poll network drives and upload images with metadata to SharePoint online: - Power Automate polls the Azure drive on scheduled intervals - When detected, images are moved to the assigned SharePoint library - The CSV is parsed and metadata is loaded to the related library and columns - The completed documents and metadata are moved to an Archive location to keep the source directory clean Other Off the Shelf tools were considered but Power Automate offered the most flexibility for future development while utilizing an existing M365 subscription.

Thursday, June 15th 2023, 9:00 am

  • Daniel Christian

    Microsoft MVP & MCT

Why Should I Consider Using Power Automate for Desktop?

While we do live in a cloud-first, desktop-first technology era, there are still several home-grown or legacy applications that are still being used. They do not have an API for cloud-based services to leverage and hence we need a robotic process automation (RPA) system that can fill in the gap. Join Daniel Christian, a Microsoft MVP and certified trainer as he introduces you to Power Automate for desktop.

Thursday, June 15th 2023, 10:40 am

  • Craig Harris

    Senior Technical Specialists at Microsoft Federal
  • Jamie Willis-Rose

    Senior Technical Specialists at Microsoft Federal

Leveraging Low Code to Respond to Federal Regulations with Agility

There are new federal regulations and executive orders all the time and it can be hard for an agency to keep their IT infrastructure in compliance. In our session we will discuss how the Microsoft Power Platform can better position agencies to be nimble and respond quickly to the ever-changing landscape. We'll show responding to a rapidly changing regulation landscape using multiple personas, both IT and Business decision makers, and speak to the key points of interest that drive both. We'll show how these personas can leverage the Power Platform to both meet the changing regulations and show measured progress along the way. We'll include demos of various Power Platform products to highlight the progress of the agency and demonstrate increased velocity by leveraging low-code tools.

Thursday, June 15th 2023, 10:40 am

  • Scott Shearer

    Microsoft MVP & MCT

Using Power Automate with Power BI

Did you know that there are at least 25 Power BI actions and triggers available in Power Automate? In this session you'll see: - How to launch a Flow from a button in Power BI - How to export a report from Power BI using a Flow - How to refresh a dataset using a Flow - Power Automate integration with Power BI Metrics - And more... All of the above will be presented via live demonstrations. If you are a Power BI user and are not yet leveraging Power Automate, this session is for you.

Thursday, June 15th 2023, 1:20 pm

  • Mike Fitzmaurice

    Vice President of North America at WEBCON

Building Business Processes that Can & Will Evolve: Product-Neutral Principles

Far more than data management apps, workflow solutions need to factor in the need for frequent change. You should expect even the best-designed models and applications to be regularly modified -- and that's a good thing. This has an impact on how to design processes, how to create forms and reports, how to connect to external data, and how to maintain internal data. This session will talk about reasons why workflow solutions need to be modified so often, why you should embrace this, and strategies and tactics for addressing it. Its advice can be applied to Microsoft Power Automate (Flow), SharePoint Designer, WEBCON BPS, FireStart, Nintex, K2, or most anything else.

Thursday, June 15th 2023, 2:40 pm

  • Paul Papanek Stork

    Microsoft MVP, MCM & MBA

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 Power Apps and Power Automate work more efficiently together. Even if you know both Power Apps and Power Automate, this session will help you get the most out of using them together.

Thursday, June 15th 2023, 4:30 pm

  • Prashant G Bhoyar

    Microsoft MVP & MCT

Implementing Microsoft Teams Governance using Power Automate, Microsoft Graph & SharePoint

The adoption of Teams is skyrocketing, and we are seeing an increase in the Microsoft Teams sprawl. One of the methods to avoid Teams Sprawl is to use automated governance using Power Automate, Microsoft Graph APIs, and SharePoint. In this demo-driven session, we will cover how to implement Teams Governance using Power Automate ( Microsoft Flow ), Microsoft Graph APIs, and SharePoint. You will learn: 1) Microsoft Teams Governance via Automation 2) Automate Microsoft Team Provisioning using Power Automate ( Microsoft Flow ), Microsoft Graph APIs, and SharePoint 3) Automate Microsoft Team Provisioning using Logic Apps, Microsoft Graph APIs, and SharePoint

Thursday, June 15th 2023, 4:30 pm

  • Ben Vanderberg

    Principal Developer Evangelist at Adobe

Add documents and e-signatures to your Power Apps

Creating PDFs and other documents does not have to be a chore. In this session, we will learn: - How to generate documents from a Canvas-based Power App using Adobe PDF Services - Add conditional logic, tables, lists, and images dynamically within a Power App using Adobe PDF Services with Power Automate - Capture legally compliant e-signatures within a Power App using Adobe Acrobat Sign This session is ideal for beginner to intermediate Power Apps users interested in bringing document experiences into their apps.

Friday, June 16th 2023, 9:00 am

  • Tamara Bredemus

    Learning Strategist Manager & Adoption Specialist at Planet Technologies

Real Life Vacation Request Solution

Don't clutter up your calendar with everyone's vacation. Create a dedicated calendar where only approved vacations show up. In this session, we will build a vacation request list, turn it into a calendar and then automate the approval process using Power Automate.

Friday, June 16th 2023, 10:20 am

  • Mark Rackley

    Microsoft MVP

Working with JSON and Arrays in Power Automate

Creating flows in Power Automate is one of the most powerful features available to the citizen developer. However, in order to truly master creating flows citizen developers need to understand how to parse the often confusing arrays and JSON objects that are returned from various processes. In this session, Mark Rackley will break down how to effectively: - Access data in an array - Parse a JSON object - Generate a sample schema Don’t miss your chance to unlock a world of powerful features in Power Automate by learning to master data in Power Automate.

Friday, June 16th 2023, 12:30 pm

  • Scott Shearer

    Microsoft MVP & MCT

Power Automate Expressions

A deep knowledge of expressions is a critical skill for a Power Automate developer. In this demo rich session, we'll take a deep dive into the types of expressions available and how to apply them. You'll see how to combine expressions, use expressions to format email text, how to use and apply date and string expressions, how to use expressions with collections and arrays and more... If you have a casual knowledge of Flow and want to "step up your game" with the use of expressions, attend this session!

Friday, June 16th 2023, 1:50 pm

  • Mike Fitzmaurice

    Vice President of North America at WEBCON

Stages and State Machines: The Ideal Way to Model and Manage Workflows

If you've heard of Power Automate Business Process Flows; they're an implementation of stage/state machine logic available to companies with Premium licensing. SharePoint Designer 2013 supported stages, and third-party options range from emulation (Nintex) to engine-level support (WEBCON). This session will start by explaining how stage-based designs and processes work, move on to why they're often far better than classic sequential flowcharts, and conclude with examples of how to build and run such solutions. It's the most useful workflow "secret" you can possibly learn.

Friday, June 16th 2023, 1:50 pm

  • Ben Vanderberg

    Principal Developer Evangelist at Adobe

Automating document processes with Microsoft Power Automate

There are so many necessary documents for an organization and being able to help automate them can make an enormous difference. In this session, we will see how you can automate that in Microsoft Power Automate with Adobe PDF Services and Adobe Sign: • Generate Word and PDF documents from data using Adobe Document Generation • Protect, Combine, OCR, and perform other actions on PDFs • Send and capture e-signatures

Friday, June 16th 2023, 1:50 pm

  • Prashant G Bhoyar

    Microsoft MVP & MCT

Power Automate for Microsoft 365 Developers

Power Automate helps us to create intelligent automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and do much more. Power Automate ( Microsoft Flow ) has opened a Pandora box of features that developers can use to build real-life enterprise-grade solutions using the low code paradigm. For example calling the SharePoint REST APIs, calling Microsoft Graph APIs, calling External web services, and integrating with Azure services such as Azure Functions and Azure Dev Ops. In this demo-driven session, we will cover how developers can use some of the rich feature sets of Power Automate ( Microsoft Flow ) and build real-life enterprise-grade business applications. You will learn: • How to consume the REST Endpoints using Power Automate ( Microsoft Flow ) • How to consume Microsoft Graph APIs using Power Automate ( Microsoft Flow ) • How to call Azure Function from Power Automate ( Microsoft Flow ) • How to build enterprise-grade business applications in Microsoft 365 using Power Automate ( Microsoft Flow ) • How to convert Power Automate ( Microsoft Flow ) to Logic Apps