Power Apps Intermediate Pathway 1: Building Smarter, Scalable Apps

Course subjects

SharePoint Integration & Data Management

• Create the app and set screen layout

• Create and configure the Work Tracker SharePoint list

• Import initial records

• Add multiple data connections

• Bind a gallery to the Work Tracker data source

• Set gallery layout and apply conditional formatting

• Bind additional controls and add input controls

• Use Coalesce for error handling

• Filter with Combo Box and understand delegation warnings

Collections & OnStart Performance

• Use collections to cache data

• Improve performance and reliability with collections

• Write OnStart logic for loading data

• Use Concurrent to speed up loading

Calculations & Variables

• Create app-level Named Formulas

• Handle formula errors and use formulas in controls

• Use screen variables with UpdateContext

• Create global variables with Set

• Use formula variables with With and understand limitations

• Check and debug values in the Variables pane

Updating & Handling Data (SharePoint)

• Update a single record using Patch (to a collection)

• Select and bulk update records using ForAll

• Sync changes from collections back to SharePoint

• Update Choice fields and Person fields

• Add new records using Defaults

• Validate forms and minimise date entry effort

• Remove records safely with warnings and confirmation prompts

Enhancing User Experience

• Use context variables to control visibility and layout changes

• Provide clear success and validation messages using Notify

• Refresh collections after data source changes to keep data in sync