Create formulas that use tables, records, and collections in a canvas app in Power Apps

Advanced
Functional Consultant
App Maker
Microsoft Power Platform
Power Apps

Note

App in a Day instructor-led training

Continue your learning journey with the App in a Day instructor-led workshop. This course provides hands-on experience for building custom apps! Browse training events.

Important

Power Virtual Agents capabilities and features are now part of Microsoft Copilot Studio, after significant investments in generative AI and enhanced integrations across Microsoft Copilot.

Some articles and screenshots might refer to Power Virtual Agents while we update documentation and training content.

Do you have need for complex formulas in your app? This module can help you write those formulas.

Learning objectives

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.

Prerequisites

A basic understanding of how to create a canvas app in Power Apps.