Power Platform Community Forum Thread Details

Why must Choice values be integers when creating a new table? I'm importing a table from a CSV, and attempting to set one of the columns to the Choice datatype. However, it says "Choice value must be an integer". Other community posts mention that it's possible to use other datatypes. How can I use Strings for the value? Why is it limited to Integers to begin with?

Categories:

Building Power Apps

Hi @DrewPowell ,

Let’s dive into the world of Choice columns in Power Apps and explore why they use integers, how to display meaningful labels, and how you can work with them:

Choice Columns in Power Apps:
- A Choice column allows users to select from a predefined list of values. These values are typically displayed as dropdown options or radio buttons.
- When creating a Choice column in Dataverse (formerly known as Common Data Service), you define the available choices (options) for that column.
Why Integers?:
- By default, Choice columns store their values as integers. But why?
  - Efficiency: Using integers simplifies data storage and indexing. It ensures efficient querying and sorting of records within the database.
  - Consistency: Integer values are consistent and predictable, making it easier to manage and maintain data integrity.
  - Internal Representation: Internally, each choice is assigned a unique integer value. These integers serve as identifiers for the options.
Mapping Choice Values:
- While the underlying storage uses integers, you can still display user-friendly labels (such as strings) to users.
- When retrieving data from a Choice column, you’ll map the integer values back to their corresponding labels.
- For example, if the integer value is 2 (representing “In Progress”), you’ll display “In Progress” in your app or form.
Displaying Choice Labels:
- To display the actual choice labels, use the Choices function in Power Apps.
- The Choices function returns a table of possible values for a lookup column. It includes both the integer values and their associated labels.
- You can use this function to provide a list of choices for users to select from in your app 1.
Example:
- Suppose you have a Status column with options:
  - 1: “Open”
  - 2: “In Progress”
  - 3: “Closed”
- In your app, use the Choices function to display the labels:
  - Choices(MyTable.Status) returns a table with both the integer values and their labels.
  - You can then display the labels (e.g., “Open,” “In Progress”) in your app interface.
Working with Choice Columns:
- When referencing a Choice column in your app, consider the following:
  - Use the integer values for data manipulation (e.g., filtering, sorting).
  - Use the labels for user-facing controls (e.g., displaying in galleries, forms).

Remember that while the storage uses integers, you can still present a user-friendly experience by mapping these values to meaningful labels. If you encounter any issues or need further assistance, feel free to ask! 😊🚀

If this post helps, then Click on the Thumbs Up below and Accept it as the solution to help others.

Thanks,

Robu1.