Microsoft Power Apps Intermediate

Power Apps Review
• Review the structure of a canvas app: screens, controls, formulas and data sources.
• Understand where app logic is usually added, including OnSelect, OnVisible, Items, Default and Visible properties.
• Review common data sources such as SharePoint lists and Dataverse tables.
• Identify the limitations of relying only on automatically generated forms.

Understanding Power Apps Variables
• What variables are and why they are useful in Power Apps.
• Using global variables with Set to store values that are needed across multiple screens.
• Using context variables with UpdateContext to control values on a single screen.
• Common uses: selected item details, screen messages, button states, pop-up panels and simple workflow stages.
• Good naming habits to make apps easier to read and maintain.

Using Collections
• Understand collections as temporary in-app tables.
• Create collections using Collect and ClearCollect.
• Update and remove records from a collection.
• Use collections to build shopping-basket style selections, offline-style working areas, review lists and temporary filtered data.
• Display collection data in a gallery and use it in expressions.
4. Going Beyond Forms
• Design screens that show records using galleries, labels, icons and input controls.
• Use expressions to control what is shown to the user.
• Build custom detail and edit screens without relying completely on display forms or edit forms.
• Use conditional formatting to highlight status, priority or missing information.
• Improve usability with clear buttons, validation messages and visibility rules.

Saving Data with Power Apps Expressions
• Saving the contents of a collection to a table
• Use Patch to create new records and update existing records.
• Use Defaults to create new records safely.
• Use LookUp to find the correct record before updating it.
• Combine validation with If and Notify before saving data.
• Understand when SubmitForm is useful and when Patch gives more control.

Working with Power Automate from Power Apps
• Understand why a Power App might call a flow.
• Create a Power Automate flow designed to be triggered from Power Apps.
• Pass values such as record IDs, text, dates and email addresses from the app into the flow.
• Trigger the flow from a button or other control in the app.
• Use flows for approvals, notifications, document creation, data updates and connecting to services that are awkward to use directly in Power Apps.

Returning Data to Power Apps from a Flow
• Return a simple value from Power Automate to Power Apps.
• Return success or failure messages so the app can guide the user.
• Return generated references, calculated values or confirmation text.
• Store the returned result in a variable and use it in labels, notifications or navigation logic.
• Plan basic error handling so users know what happened.

Power Apps Review
• Review the structure of a canvas app: screens, controls, formulas and data sources.
• Understand where app logic is usually added, including OnSelect, OnVisible, Items, Default and Visible properties.
• Review common data sources such as SharePoint lists and Dataverse tables.
• Identify the limitations of relying only on automatically generated forms.

Understanding Power Apps Variables
• What variables are and why they are useful in Power Apps.
• Using global variables with Set to store values that are needed across multiple screens.
• Using context variables with UpdateContext to control values on a single screen.
• Common uses: selected item details, screen messages, button states, pop-up panels and simple workflow stages.
• Good naming habits to make apps easier to read and maintain.

Using Collections
• Understand collections as temporary in-app tables.
• Create collections using Collect and ClearCollect.
• Update and remove records from a collection.
• Use collections to build shopping-basket style selections, offline-style working areas, review lists and temporary filtered data.
• Display collection data in a gallery and use it in expressions.
4. Going Beyond Forms
• Design screens that show records using galleries, labels, icons and input controls.
• Use expressions to control what is shown to the user.
• Build custom detail and edit screens without relying completely on display forms or edit forms.
• Use conditional formatting to highlight status, priority or missing information.
• Improve usability with clear buttons, validation messages and visibility rules.

Saving Data with Power Apps Expressions
• Saving the contents of a collection to a table
• Use Patch to create new records and update existing records.
• Use Defaults to create new records safely.
• Use LookUp to find the correct record before updating it.
• Combine validation with If and Notify before saving data.
• Understand when SubmitForm is useful and when Patch gives more control.

Working with Power Automate from Power Apps
• Understand why a Power App might call a flow.
• Create a Power Automate flow designed to be triggered from Power Apps.
• Pass values such as record IDs, text, dates and email addresses from the app into the flow.
• Trigger the flow from a button or other control in the app.
• Use flows for approvals, notifications, document creation, data updates and connecting to services that are awkward to use directly in Power Apps.

Returning Data to Power Apps from a Flow
• Return a simple value from Power Automate to Power Apps.
• Return success or failure messages so the app can guide the user.
• Return generated references, calculated values or confirmation text.
• Store the returned result in a variable and use it in labels, notifications or navigation logic.
• Plan basic error handling so users know what happened.

There is no formal examination or accredited assessment included with this course.

You’ll develop and demonstrate your understanding through practical exercises, hands-on activities and business scenarios completed throughout the training day. These activities will allow you to apply intermediate techniques involving variables, collections, expressions, data sources and Power Automate integrations.

There is no formal examination or accredited assessment included with this course.

You’ll develop and demonstrate your understanding through practical exercises, hands-on activities and business scenarios completed throughout the training day. These activities will allow you to apply intermediate techniques involving variables, collections, expressions, data sources and Power Automate integrations.

• One day of instructor-led training delivered by a Microsoft Certified Trainer.
• A Microsoft 365 training environment for use during the course.
• Comprehensive course notes and supporting learning materials.
• Practical exercises and business-focused activities.
• A recording of the training day if you attend a live virtual course.
• NILC course completion certificate.

• One day of instructor-led training delivered by a Microsoft Certified Trainer.
• A Microsoft 365 training environment for use during the course.
• Comprehensive course notes and supporting learning materials.
• Practical exercises and business-focused activities.
• A recording of the training day if you attend a live virtual course.
• NILC course completion certificate.

Before attending this course, you should have previous experience creating and using canvas apps in Microsoft Power Apps or have completed an introductory Power Apps course.

You should be able to:

• Create and navigate between screens.
• Add and configure common controls.
• Connect an app to a data source.
• Create and use display and edit forms.
• Understand basic Power Apps formulas and properties.
• Work with common data sources such as SharePoint lists or Dataverse tables.

Familiarity with Microsoft 365 applications and common business processes would also be beneficial.

Formal programming experience is not required, but you should be comfortable working with formulas and expressions.

Before attending this course, you should have previous experience creating and using canvas apps in Microsoft Power Apps or have completed an introductory Power Apps course.

You should be able to:

• Create and navigate between screens.
• Add and configure common controls.
• Connect an app to a data source.
• Create and use display and edit forms.
• Understand basic Power Apps formulas and properties.
• Work with common data sources such as SharePoint lists or Dataverse tables.

Familiarity with Microsoft 365 applications and common business processes would also be beneficial.

Formal programming experience is not required, but you should be comfortable working with formulas and expressions.