Author a basic formula that uses tables and records in a Power Apps canvas app
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 want to use tables and records and filter data in your canvas app? This module will focus on the differences between a table and a record and how to utilize both within your Power Apps canvas app.
Learning objectives
In this module, you will:
- Understand tables and records in Power Apps
- Understand how to use Collect and ClearCollect to make multi-column tables
- Add a collection as a data source to a gallery
- Filter your table of data
- Use the LookUp function
Prerequisites
A basic understanding of how to create a canvas app in Power Apps. This should include adding controls to the app and using a basic formula to edit a control and its behavior. An understanding of working with data in Power Apps is also helpful but not required.