Use Dataverse choice columns with formulas

App Maker
Microsoft Power Platform
Power Apps
Microsoft Dataverse


App in a Day Instructor-Led Training

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


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

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

Explore how you can use Power Fx formulas to work with the Choice column in Microsoft Dataverse. These column data types present the user with a fixed list of values that are defined by the maker.

Learning objectives

In this module, you will:

  • Discover the Choice field basics.
  • Learn when to use choice or lookups.
  • Filter data on choice values.


  • An environment with Microsoft Dataverse
  • Basic Microsoft Power Apps maker experience
  • Fundamental knowledge of setting up Microsoft Dataverse