Power Apps - Enhanced Skills

Enhance your Power Apps skills with practical advanced concepts for developers and business users.

What you'll learn

Uploading files in Power Apps.

Creating pop-up windows.

Using Dataverse with Canvas Apps.

Managing data in tables.

The PDF function.

Managing complex variables.

Understanding delegation and how to circumvent it.

Managing containers.

Using query strings with the Param function.

Utilizing relational sizing with Power Apps.

Requirements

Basic knowledge of Power BI, SharePoint, and Power Apps, along with intermediate proficiency in Excel.

Description

Microsoft Power Apps became available in 2016.  Since then, it has continually added features and functionality for technical personnel and citizen developers alike.  Inevitably, developers want to accomplish very specific tasks, and those tasks do not fit neatly into a beginner, intermediate, or advanced level class.Power Apps – Enhanced Skills is a course based upon customer needs and requests.  All are invited to take it, as long as the basics have been mastered.  This course contains ten chapters covering a range of topics.  These include:Uploading Files is a common requirement.  Learn which controls and functions are required to upload a single file or multiple files to a data source, including SharePoint.  Pop-up windows, similar to dialog boxes, are another favorite.  Creating them is not obvious but it can be done.Canvas apps can interact with data from Microsoft’s Dataverse.  Model-driven apps are not always required.  Learn how to create a table based on another table and then interact with it from a canvas app.  Managing that data is the next step.  This is often done with a variety of functions, like Patch, ForAll, Table, Lookup, and more.  Each function is given thorough coverage.Taking data from a screen and sending as a PDF document via email is almost a necessity now so techniques to do this are covered.  When those PDFs need to be sent to a SharePoint site, a slightly separate set of skills are needed, and this process is explained in detail.Users who work with complex variables often need to merge them.  The functions required to do this are covered as well, using Collect, ClearCollect, and others.Delegation issues eventually challenge all developers of all levels.  Learn what delegation is, its limits, and how to push past those limits.Responsive apps adjust themselves to the dimensions of the mobiles devices on which they run.  Doing this properly requires understanding containers in containers, initial screen properties, and other issues.  Watch how these challenges are handled.When Power Apps need to talk to each other, this may be done by passing parameters in a URL.  Learn how this works and make your own apps talk to each other!

Overview

Section 1: Introduction

Lecture 1 Welcome and Introduction

Section 2: Uploading Files in Power Apps

Lecture 2 Understanding What's Involved

Lecture 3 Preparing a Screen for an Upload

Lecture 4 Creating a Power Automate Upload Flow

Lecture 5 Uploading a Single File

Lecture 6 Uploading Multiple Files

Section 3: Creating Pop Up Windows

Lecture 7 Understanding What's Involved

Lecture 8 Preparing a Screen for a Pop-up Window

Lecture 9 Creating a Pop-up Overlay

Lecture 10 Creating a Group and Controlling Visibility

Lecture 11 Adding Functionality to the Pop-up Form Buttons

Section 4: Using Dataverse within the Canvas Apps

Lecture 12 Understanding Microsoft Dataverse

Lecture 13 Using Power Query to Create a Table

Lecture 14 Building a Canvas App from a Dataverse Table

Section 5: Managing Data in Tables

Lecture 15 Understanding Data Management

Lecture 16 Creating a New Record

Lecture 17 Updating a Single Record

Lecture 18 Creating New Records

Section 6: The PDF Function and Printing Multiple Pages

Lecture 19 Understanding PDF Options

Lecture 20 Creating a PDF

Lecture 21 eMailing a PDF

Lecture 22 Creating a Flow in Power Automate

Lecture 23 Sending a PDF to SharePoint for Downloading

Section 7: Managing Complex Variables

Lecture 24 Understanding Complex Variables

Lecture 25 Managing Complex Variables

Section 8: Understanding Delegation and How to Circumvent it

Lecture 26 Understanding Delegation

Lecture 27 Understanding Delegation Limits

Lecture 28 Changing Delegation Settings

Section 9: Managing Containers

Lecture 29 Understanding Containers

Lecture 30 Using Containers

Section 10: Using Query Strings with the Param Function

Lecture 31 Understanding the Param Function

Lecture 32 Using the Param Function

Section 11: Utilizing Relational Sizing within Power Apps

Lecture 33 Understanding Responsive Apps

Lecture 34 Understanding App and Screen Dimensions

Section 12: Conclusion

Lecture 35 Course Recap

Section 13: Power Apps - Enhanced Skills Assessment

Ideal for users seeking to enhance Power Apps capabilities with advanced concepts.