Microsoft
Microsoft Logo

Master advanced formula techniques and custom updates 

  • Offered byMicrosoft

Master advanced formula techniques and custom updates
 at 
Microsoft 
Overview

Learn how to use Dataverse relationships in canvas apps from Power Apps

Duration

5 hours

Total fee

Free

Mode of learning

Online

Schedule type

Self paced

Difficulty level

Advanced

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Details Icon

Master advanced formula techniques and custom updates
 at 
Microsoft 
Course details

Skills you will learn
What are the course deliverables?
  • Using the relationships properly means that apps can hide unnecessary complexities of the data model
  • Imperative development techniques can help you achieve the goal for your app
  • Learn about different development methods and different variables in Power Apps
  • Learn how to unpack a canvas app from a single monolithic file to many files, each describing an individual part of the app
More about this course
  • This learning path will help you use advanced formulas and perform custom updates
  • This learning path can help you prepare for the Microsoft Certified: Microsoft Power Platform App Maker Associate certification
  • This learning path helps prepare you for Exam PL-100: Microsoft Power Platform App Maker
  • Explore how you can use Power Fx formulas to work with the Choice and Choices columns in Microsoft Dataverse

Master advanced formula techniques and custom updates
 at 
Microsoft 
Curriculum

Create formulas that use tables, records, and collections in a canvas app in Power Apps

Formulas that process multiple records

Math operations on tables

Combine and separate records

The For All function

Lab - Using the For All function in a gallery

Check your knowledge

Summary

Use Dataverse choice columns with formulas

Introduction

Filter Dataverse choice columns with Power Fx formulas

Modify choice and choices values

Exercise - Dataverse choice columns

Check your knowledge

Summary

Reduce complexity in your data model with Dataverse table relationships

Introduction

Work with one-to-many relationships

Work with many-to-many relationships

Exercise - Work with Dataverse relational data

Check your knowledge

Summary

Use imperative development techniques for canvas apps in Power Apps

Imperative versus declarative development

The three types of variables in Power Apps

Global variables

Contextual variables

Collections

Additional variable concepts

Exercise - Using the variables and collections

Check your knowledge

Summary

Perform custom updates in a Power Apps canvas app

Sometimes you need something more than forms

Using the Patch function to create and edit records

Deleting record(s) from data sources and collections

Using Patch function to update a Gallery

Check your knowledge

Summary

Work with canvas app source code

Introduction

Exercise - Use source code to create an app and install tools

Work with YAML

Exercise - Use source code in Visual Studio Code

Check your knowledge

Summary

Other courses offered by Microsoft

Free
2 hours
Intermediate
Free
1 hours
Beginner
Free
4 hours
Intermediate
Free
5 hours
Beginner
View Other 1171 CoursesRight Arrow Icon
qna

Master advanced formula techniques and custom updates
 at 
Microsoft 

Student Forum

chatAnything you would want to ask experts?
Write here...