Author a basic formula that uses tables and records in a Power Apps canvas app

Intermediate
Business User
App Maker
Functional Consultant
Power Platform
Power Apps

Note

Effective November 2020

  • Common Data Service has been renamed to Microsoft Dataverse. Learn more.

  • Some terminology in Microsoft Dataverse has been updated. For example,entity is now table and field is now column. Learn more.

Modules will be updated soon to reflect the latest terminology.

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.