Washington, D.C.

Power Apps

Sunday, December 12th 2021, 9:00 am

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

WRK106 - Advanced Power Apps and Power Automate: Workarounds for Common Problems

Spend any amount of time in the Power Platform forums and you will begin to see a lot of similar questions asked over and over again. In this workshop we will look at some of the most common issues Citizen Developers encounter when trying to develop applications and workflows in the Power Platform. We'll examine each type of problem, analyze why they occur, and provide workarounds that you can use when you encounter them. The workshop will be divided into two parts. In the first we'll concentrate on Power Apps and in the second we'll look at Power Automate. Here is a general list of the overall topics we will cover: • Morning: Power Apps ○ Delegation ○ Working with Dates and Times ○ Conditional Formatting of data ○ Passing Data to and Retrieving Results from a Flow • Afternoon: Power Automate ○ Using Conditions and Switches effectively ○ Handling Loops and Parallel Branches ○ Working with Large Data Sources ○ Implementing Error Checking/Correction

Sunday, December 12th 2021, 9:00 am

  • William Huneycutt

    Microsoft MVP

WRK104 - Business Process Automation with Power Apps and Power Automate (Flow)

In 2016, Microsoft introduced two new tools in Office 365: Power Apps and Flow (now Power Automate). Power Apps is designed for power users everywhere to connect, create and share business apps and forms for your team. Power Automate is designed to create automated workflows between your favorite apps and services, such as SharePoint, to get notifications, synchronize files and collect data. As these products have evolved and matured since their release, Microsoft has made clear it is time for organizations to consider moving away from SharePoint Designer and InfoPath. This workshop is a deep dive into the capabilities of Power Apps and Power Automate as organizations transition from SharePoint Designer and InfoPath. In this workshop, users will learn how to get started quickly with Power Apps to create rich forms and apps complete with an Microsoft Office-like experience. • Users will learn how to create an app or form from scratch for use in the web or on mobile platforms. • Discover how to use built-in connections to connect Power Apps to cloud services such as Office 365 and OneDrive, and on-premises systems such as SharePoint. • Detailed comparison of Power Apps and InfoPath. This workshop will also discuss how to work smarter and more efficiently by automating workflows across the most common apps and services. • Users will learn how to build, manage, and administrator Flows in your environment. •  Learn to create Flows from scratch or by using pre-built templates in the visual designer. •  Discover how to connect Power Automate to over 100 data sources. •  Detailed comparison of SharePoint Designer workflows and Power Automate.. The future of SharePoint is exciting, and the addition of Power Apps and Power Automate can help to address the complex business processes faced by today’s business teams.

Sunday, December 12th 2021, 9:00 am

  • Scott Shearer

    Microsoft MVP, MCT
  • Wes Preston

    Microsoft MVP

WRK108 - Power Apps and Power Automate (Flow) for SharePoint Bootcamp

Power Apps and Power Automate are the successors to InfoPath and Designer Workflows for SharePoint. In this demo rich workshop, you'll spend the morning learning how to customize your SharePoint list forms with Power Apps and automate processes with Power Automate. You'll see how Power Apps can be used to make many of the customizations for which you may have used InfoPath in the past. We'll also cover how Power Automate can be used to do the same tasks for which you may be currently using Designer workflows - and much more..... Live demos will be used to illustrate the topics covered. In the afternoon, you'll have the opportunity to "take the wheel" and test out Power Apps and Power Automate for yourself. Through a series of hands-on labs, you'll gain first hand experience in customizing SharePoint list forms with Power Apps and automating business processes in SharePoint using Power Automate. Your instructors will be there to assist anytime you have questions or need some help. 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. Attend this session and say goodbye to InfoPath and SharePoint Designer workflows. Gain the skills you'll need to immediately start customizing your Office 365 SharePoint sites with Power Apps and Power Automate.

Monday, December 13th 2021, 9:00 am

  • Daniel Glenn

    Microsoft MVP
  • Vlad Catrinescu

    Microsoft MVP, MCT

WRK401 - Becoming an Expert Power User in Microsoft 365

Join Microsoft MVPs Vlad and Daniel in this full day workshop to help you take your skills to the next level. Go beyond the basics and experience tools within Microsoft 365 in a new, exciting way. If you want to gain deeper knowledge in Microsoft 365 and understand the optimal way to implement the tools, this workshop is for you. In this full day workshop, we will cover many topics, including: • Managing your Microsoft Teams • Configuring a SharePoint Online site the modern way – including dynamic content • Document management features such as Content Types and Site Columns • Creating workflows using Power Automate • Customizing Microsoft Lists • & more! After this workshop, you will have the knowledge and skills necessary to become the Microsoft 365 Champion inside the organization. Instead of simply using the Microsoft 365 products, you will be able to configure and personalize them to make your whole organization more productive.

Tuesday, December 14th 2021, 1:30 pm

  • Wes Preston

    Microsoft MVP

PWR103 - Power Apps: New Approaches for SharePoint Data Solutions

Break free of the limitations of SharePoint lists. Power Apps integration with SharePoint introduces new options for Power Users to access, store, or extend existing data solutions beyond the boundaries of traditional lists. In this session, we’ll cover new locations for data storage, new capabilities of these containers, and the pros and cons of choosing one over the other while still surfacing solutions via SharePoint or Teams.

Tuesday, December 14th 2021, 1:30 pm

  • Paul Papanek Stork

    Microsoft MVP, MCSM, MBA

FLO103 - Using Power Apps and Microsoft Power Automate (Flow) 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 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.

Tuesday, December 14th 2021, 3:00 pm

  • Richard Toland

    Principal Architect/Developer at Perpetual Reality

AZR104 - Gateway Drugs: Power Apps/BI & Flow for on-prem, just the beginning. Now Azure Data Factory

For some admins and developers, the demand for cloud capabilities using data accessible only on-prem has increased as many organizations continue to employ Hybrid architectures. To meet that need (and the security constraints that accompany on-prem data), the Microsoft Data Management Gateway gives us better integration to this data and in more secure ways, all while leaving it at the source. Coupled with the Azure Data Factory, your on-prem content can architecturally reach a number of connections never possible before by leveraging the unprecedented scale and compute power throughout the breadth of Azure services. This session will illustrate how to leverage on-prem SharePoint content to interface with and drive cloud services through the secure Data Management Gateway and Azure Data Factory integrations. We’ll cover the setup and configuration of the Gateway, the Factory, and our data connections, as well as some gotcha’s and pitfalls along the path to becoming a full Gateway/Hybrid addict.

Tuesday, December 14th 2021, 4:20 pm

  • Daniel Glenn

    Microsoft MVP

PWR105 - Use Your On-premises Data with Power Apps, Power BI, and Power Automate (Flow)

Microsoft Power BI, Power Automate (Flow) and Power Apps are powerful cloud tools that can take your on-premises data, stored in systems like SQL and SharePoint, to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy. In this session, we will discuss the benefits of using the cloud tools and how workflow, analytics, and business apps can utilize your on-premises data. We will setup a data gateway, connect to on-premises data sources, and discuss how to use that data in Microsoft 365 to create rich business solutions. You will walk-away from this session with the knowledge you need to immediately start using your on-premises data with Microsoft 365.

Wednesday, December 15th 2021, 10:30 am

  • Wes Preston

    Microsoft MVP

PWR201 - Power Apps: New Approaches to the Traditional SharePoint List View

Yes, yes... Power Apps is an excellent tool for custom forms and facilitating business processes (with Microsoft Flow). Did you know Power Apps are also capable of building dramatically better list views? It's no coincidence that Power Apps are surfaced in the SharePoint interface via the View dropdown control. See how Power Apps can be used to display richer and more functional views of your data - now, directly in SharePoint and Teams with supported web parts and components.

Wednesday, December 15th 2021, 2:40 pm

  • William Huneycutt

    Microsoft MVP

PWR203 - Business Process Automation with Power Apps and Power Automate (Flow)

In 2016, Microsoft introduced two new tools for Office 365: Power Apps and Flow (now Power Automate). Power Apps is designed for power users everywhere to connect, create and share business data with your team on any device in minutes. Power Automate (Flow) is designed to create automated workflows between your applications and services, such as SharePoint, to get notifications, synchronize files and collect data.  In this session, users will learn how to get started quickly with the Power Apps to create apps with an Microsoft Office-like experience. Users will discover how to use built-in connections to connect Power Apps to services such as SharePoint, Office 365, and OneDrive, and even on-premises systems such as SharePoint. Users will also learn how to share Power Apps with coworkers to take advantage of an app you created.  This session will also discuss how to get started with Power Automate. Users will learn how to take advantage of pre-built templates for creating workflows. Users will also learn how to create their own flows in an easy visual designer that works anywhere on the web. Finally, we'll discuss how to manage your Flows during and after runtime. The future of SharePoint is exciting, and the addition of Power Apps and Power Automate can help to address the myriad of business processes faced by today’s business teams.

Thursday, December 16th 2021, 10:40 am

  • Gokan Ozcifci

    Microsoft MVP, RD

PWR302 - Power Apps and SharePoint: Better together

Since Microsoft announced the long-term deprecation cycle for InfoPath, business users, decision-makers and power users have been waiting for better answers. Wait no longer! Power Apps is officially here as your InfoPath replacement, and even better – Microsoft is releasing Power Apps templates to get us started. Because Power Apps is seamlessly integrated into SharePoint, there's no need to manage forms from two places: permissions are inherited from and having Power Apps integrated with SharePoint gives you access to many powerful features, such as analytics reports, easy point-and-click rules for conditional formatting, and connections to other data sources.  In this session, we'll learn firsthand how we can extend our SharePoint experience with Power Apps - without writing a single line of code! We will not only cover the theory, but we will look at multiple examples expired by my main customers, and real-life scenarios in a live demo.

Thursday, December 16th 2021, 1:00 pm

  • Kanwal Khipple

    Microsoft MVP

INT303 - Beyond the Intranet: Digital Workplace Apps, Solutions and Bots

Many organizations have already established a powerful Office 365 Intranet, but they haven't answered the question What's next . In this session we will respond to the ever-increasing demand for powerful and integrated solutions that support users' needs across their digital workplace and beyond. Leveraging Office 365 means that you have access to entirely new ways of building solutions faster than ever before. The best part? It's not just IT that can build these great solutions! Join Kanwal Khipple as he shares real world examples, and best practices for how organizations can deliver more value with integrated solutions built by the business, by IT, or a combination of both. In this session, we will talk about Bots, Microsoft Flow, PowerApps, Microsoft Forms, Integrations, Office 365 development, industry innovation and more!