- Do you have need for complex formulas in your app? This module can help you write those formulas.
In this module, you will:
- Utilize formulas that process multiple records.
- Use the Concat function to combine text from multiple records.
- Utilize the Countrows, CountIf, ForAll.
- Perform math operations on data in a table.
- Explore how you can use Power Fx formulas to work with Microsoft Dataverse choice and choices columns. These column data types present the user with a fixed list of values defined by the maker.
In this module, you will:
- Discover the Choice field basics.
- Learn when to use choice or lookups.
- Filter data on choice values.
- Learn how to use Microsoft Dataverse relationships in canvas apps from Microsoft Power Apps.
In this module, you will:
- Discover various Microsoft Dataverse relationship types.
- Learn how to use one-to-many relationships.
- Learn how to use many-to-many relationships.
- Learn how to use imperative vs. declarative development.
This module explains how to:
- Understand imperative vs. declarative development.
- Understand the variables in Power Apps.
- Understand when to utilize each of the three different types of variables.
- With some Power Apps canvas apps, a form isn't the solution. This module focuses on how to perform custom updates when your data isn't in a form.
This module explains how to:
- Use the Patch function to update your data.
- Understand how the Defaults function is used to create new records with Patch.
- Use the Remove and RemoveIf functions to delete records.
- Determine whether to use Clear and Collect or ClearCollect in their scenario.
AI Engineer - Learn how to integrate AI into software applications
The Most Addictive Python and SQL Courses
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- 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 ForAll function
- Exercise- Using the ForAll function in a gallery
- Module assessment
- 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
- Module assessment
- Summary
- Perform custom updates in a Power Apps canvas app
- Sometimes you need something more than forms
- Use the Patch function to create and edit records
- Delete records from data sources and collections
- Use the Patch function to update a Gallery
- Module assessment
- Summary