Master Microsoft Power Apps Table functions

Compare behavior and non-behavior formulas in Power Apps, showing how behavior formulas drive actions like reset and navigate, while non-behavior formulas mirror Excel cell logic.

Bridge behavior and non-behavior properties in Power Apps with set to create global variables. Bind these variables, like var_save_button_mode, to display mode and enable the save button on text changes.

Master Power Apps records by creating a JSON-like record with set and var_person, including first name, last name, and age. Learn that set replaces the whole record.

Understand how context uses screen-scoped records and contextual variables to replace global set variables, enabling modular design and easier debugging in Power Apps.

Learn to convert JSON arrays into Power Apps tables by grouping records into arrays, building simple and complex tables with matching columns, and displaying them in a data table.

Explore how Power Apps handles loops with for all, build collections with collect, and generate sequences for dropdowns and date ranges, enabling constrained date picking.

Explore how to implement conditions in Power Apps using if and switch, including nesting, boolean checks, and color logic with a dropdown and a show color checkbox.

Explore how the If function in Power Apps handles conditions and returns values, and learn to use Collect, UpdateContext, and Set within ForAll, including examples of behavior inside loops.

Discover how the json function in Power Apps converts tables and complex data into json strings for external services and rest APIs, with formatting options like indent for readable output.

Explore table functions in Power Apps through a scenario-based order form project: build an order with items, unit, price, quantity, subtotal, and save to SharePoint or a data warehouse.

Build a Power Apps canvas app with an order placement form, edit form submission, and in-app collections to manage a one-to-many orders-to-items relationship offline.

Explore how the Power Apps collect function creates and updates collections (global tables) across screens, adding records, creating new fields, and how clear differs from collect.

Decide between using a collection or a local variable to store shopping cart items, then build an order items collection with item, quantity, and unit price.

Explore three approaches to calculating subtotals in a Power Apps app: adding a subtotal field, computing in the gallery, and using the addColumns table function for dynamic results.

Explore removing items in Power Apps with remove and removeIf, understand deleting a specific record from a collection, and the importance of a unique identifier for reliable deletes.

Fix the Power Apps remove function by deleting the gallery item from the collection with a matched item, then adopt a proper delete flow using a popup confirmation.

Learn to delete a selected gallery item in Power Apps with a confirmation dialog, using a unique id and remove if to avoid deleting duplicates.

Create and link SharePoint lists for project one orders and order items using a lookup, then group by order. Explore Power Apps table functions for data handling and collect-based insertion.

Explore the layers of the Collect function in Power Apps, inserting records into SharePoint or Dataverse, handling field names and static names, and clearing data with Remove.

Use collect to append a whole table to another table, like a SharePoint list. Create a contextual table with the table function and map its fields to the target schema.

Power Apps uses JSON as a silver bullet to explore complex data formats, converting objects to JSON, displaying results in a text box, and building records with id and value.

Connect Power Apps to SharePoint to add orders, auto-fill the order date, and capture the new order’s id and title with LastSubmit using table functions.

Learn to insert all order items in one line with collect and map a local table to SharePoint by renaming columns, adding an order field, and handling internal names.

Explore three ways to obtain a SharePoint list internal field name: use the SharePoint online client browser, convert a row to json, or bind to a Power Apps data table.

Clean up your Power Apps demo by validating required fields and data integrity when adding items to SharePoint lists. Explore collect behavior with invalid records for a reliable client demo.

The lecture compares search, filter, and lookup, showing that search returns a collection with or logic, filter uses and logic for multiple conditions, and lookup returns a single record.

Create a Power Apps canvas app that lists order items with subtotal over 20, using filter and starts with search, connected to SharePoint orders and items, with related order details.

Explore select, filter, and lookup in Power Apps to show items with subtotal over $20 and support starts with search, then display the related order and all its items.

Use the distinct function in Power Apps to create a unique country list from a SharePoint financial sample and filter records by selected countries with a multi-select control.

Add an all countries option to a distinct country list by inserting a top item in a local collection, then use a dropdown to filter or show all.

Master Power Apps sorting by choosing between the sort function and sort by columns, using ascending or descending order, with examples like unit sold and a client-driven sort fields dropdown.

Learn to implement sort by column in Power Apps using a dropdown of field names and the table function to map display values to static fields, while preserving filters.

Learn to calculate sum and average in a data table with Power Apps, using sum, average, filters, and formulas to create dynamic totals that respond to country selections.

Master Microsoft Power Apps table functions focuses on counting records in Dataverse tables to manage pending tasks in a canvas app, including displaying active tasks and marking them as complete.

Learn to add a new task to Dataverse using an edit form linked to the employee tasks table, including status and due date, with submit and navigation to pending tasks.

Learn how to populate a Dataverse choice field with the Power Apps choices function, set a default active value, and patch updates to my task status using plain text conversions.

Explore how to count in Power Apps with CountF (CountIf) and CountRows, compare their behavior, and show how to extract a single-column table with show column for conditional counts.

Learn how count and countA differ in Power Apps: count targets a single column and numeric fields while countA handles all data types, excluding nulls and blank strings.

Use the patch function to update a single field in a data source by selecting a record from a data table and updating the manufacturing price with proper type conversion.

Learn how the patch function can update or create records in a data source like SharePoint, compare patch with collect, and use defaults to insert new records, avoiding unintended inserts.

Patch complex data types in Power Apps using the patch function. Explore date fields, choice fields, and user fields with lookup and JSON approaches.

Explore patch and updateIf in Power Apps to update multiple records by a condition, such as updating manufacturing price or applying a 10% sales price increase.

Create a per-country grouped data view showing total units sold, manufacturing price, and average with total gross sales, and add a confirmation dialog before bulk updates.

Learn to group data by title with Power Apps group by function, creating a two-column table (title and g r p result) and displaying grouped records in nested galleries.

Master Microsoft Power Apps table functions demonstrates simplifying a not-so-easy group by with show columns and rename columns to create country-level summary of units sold, manufacturing price, and gross sales.

Explore how to turn a read-only data table into an editable grid using a gallery to budget GL accounts by quarter, matching excel-like finance needs.

Enable autosave in a PowerApps gallery using onChange and patch to SharePoint, converting input with value for numeric fields, and assess focus loss, concurrency, and the no-undo trade-offs.

Add a save and undo button to every row in a Power Apps gallery, track updated rows with a collection, and patch changes back to SharePoint while managing button states.

Create a single save button that patches all modified gallery records to SharePoint using Power Apps table functions. Use a local collection with is_modified and for all to patch.

Learn to highlight changed rows in a gallery by tracking an isModified flag in a local collection and conditionally color-coding updated items for clear user feedback in Power Apps.

Review the course's coverage of power apps table functions, including behavior versus non-behavior formulas, variables, records and contexts, collections, patch and json usage, and sorting, filtering, and group by.

Address the elephant in the room: the delegation warning in Power Apps, and outline next course on how to fix it, covering basics, complex parts, and hidden delegation warnings.

Master Microsoft Power Apps table functions and learn to address delegation warnings, then explore recommended Power Automate courses and how to claim a free course voucher by sharing your certificate.