Use advanced formula techniques and custom updates in Power Platform

Overview

Discover the power of advanced formula techniques and custom updates in Microsoft Power Platform. This course, provided by Microsoft Learn, delves into a range of complex subjects designed to enhance your skills in building intuitive applications with Microsoft Power Platform.

• Module 1: Master the art of writing complex formulas crucial for processing multiple records within your apps. Techniques covered include:
• Using Concat function to amalgamate text across records.
• Employing Countrows, CountIf, and ForAll functions.
• Executing mathematical operations on table data.
• Module 2: Delve into Power Fx formulas for managing Microsoft Dataverse's choice and choices columns which offer predefined values tailored by creators. Key learnings include:
• Basics of Choice field and differences between choice and lookups.
• Techniques to filter data based on choice values.
• Module 3: Explore the usage of Microsoft Dataverse relationships in canvas apps to enhance database interactions.
• Understanding different types of Dataverse relationships.
• Methods to employ one-to-many and many-to-many relationships.
• Module 4: Differences between imperative and declarative development within Power Apps are examined alongside variables management.
• Comparative analysis of imperative vs declarative approaches.
• Understanding variable types within Power Apps and their applications.
• Module 5: Learn to perform custom updates in canvas apps where standard forms do not suffice. Key functions discussed include:
• The Patch function for data updates.
• Defaults function for creating new records.
• Using Remove and RemoveIf for record deletion.
• Optimal use of Clear, Collect, and ClearCollect functions.
• Module 6: Gain insights on deconstructing a canvas app from a monolithic file to several files, each representing a component of the app, through practical exercises.
• Techniques for unpacking and repacking apps.
• Understanding canvas app components in YAML format.

This course explores comprehensive techniques and skills centered around modifying, updating, and managing applications efficiently using Power Platform tools, focusing on Microsoft Dataverse and YAML courses.

Syllabus

Taught by

Tags

united states