Power Apps and Power Automate: Building Business Solutions

Overview Building Business Solutions with Power Apps and Power Automate is a 2-day training class designed for people who have already begun working with PowerApps and are ready to move their Power Apps and Power Automate skills to the next level. This class is designed for the "citizen developer" (an individual with subject matter expertise but with little formal IT background) who is developing applications on their own or in coordination with "pro" developers. _ Students will learn best practices for building Model-Driven (Dataverse) and canvas apps and flows to update and manage content in Azure SQL, SharePoint Online, Excel workbooks, and OneDrive for Business. Prerequisites Students should already be familiar with Microsoft Excel, Office 365 and SharePoint Online. It is also recommended that students attend ONLC's Power Apps: Introduction for End Users before taking this more advanced level class or have the equivalent hands-on experience with PowerApps and Power Automate. For the prerequisite class, ` See Power Apps: Introduction for End Users

COURSE OUTLINE Review of Microsoft Power Platform What is Microsoft Power Platform? The business value of Microsoft Power Platform Data Connectors Data loss prevention, compliance, privacy, accessibility Create tables in Dataverse Introduction to Microsoft Dataverse Table characteristics Dual-write vs virtual tables Dataverse auditing Exercise: Create a Microsoft Dataverse table Import data into your Microsoft Dataverse database Exercise: Create a custom table and import data Module 3: Manage tables in Dataverse Identify tables and table types in Dataverse Create a custom table Enable attachments within a table Licensing requirements for each table type Lab: Create a new custom table and enable attachments Module 4: Create and manage columns within a table in Dataverse Define columns in Microsoft Dataverse Column types in Microsoft Dataverse Add a column to a table Create a primary name column Restrictions that apply to the columns in a table Create a numbering column Create an alternate key Exercises Create a relationship between tables in Dataverse Relate one or more tables Relationship types that are available in Microsoft Dataverse Create a one-to-many relationship between tables Create a many-to-many relationship between tables Edit or delete relationships Exercise - Create two tables and relate them by using a one-to-many relationship Working with choices in Dataverse Define a choice column Standard choices column Lab: Create a new choice or modify an existing choice Get started with security roles in Dataverse Introduction to environment roles Understand environment roles Adding or disabling an environment user Understand security concepts in Dataverse Understand user security roles and security role defaults Exercise - Create a custom role Check the roles that a user belongs to Configure Dataverse teams for security Configure Dataverse group teams for security Get started with model-driven apps in Power Apps Introducing model-driven apps Building blocks of model-driven apps Design model-driven apps Exercise Exercise - Control security when sharing model-driven apps Incorporate business process flows Exercise - Create a model-driven app Configure forms, charts, and dashboards in model-driven apps Forms overview Form elements Configure multiple forms Use specialized form components Configure views overview Configure grids Use specialty views Configure charts overview Dashboards overview Use interactive streams and tiles Get started with Power Automate Introducing Power Automate Exercise - Create your first flow Exercise - Create recurring flows Exercise - Monitor incoming emails Exercise - Share flows Troubleshoot flows Use Dataverse triggers and actions in Power Automate Introduction Dataverse triggers Use triggers Work with Dataverse actions Extend Dataverse with Power Automate Introduction Set up a flow and configure its trigger Email Dataverse record Add to-do items Test and run your flow Introduction to expressions in Power Automate Introduction to expressions Get started with expressions Notes make things easier Types of functions Write complex expressions Exercise - Creating a manual flow and using expressions