Author a basic formula that uses tables and records in a Power Apps canvas app
Note
Come join us for the first official Microsoft Power Platform Conference. This event is jam-packed with Microsoft’s senior thought leaders, software engineers, and community experts - all focused on uniting humanity and technology. Do not miss this exciting and fun in-person experience.
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.