Issue with Concatenating Choice Column Label Instead of Value in Power Apps

(1) Share

Report

Posted on by priya_

Hi everyone,

I have a formula in Power Apps where I'm trying to concatenate a registration number with the year from a Choice column:

Concatenate('Registration Number', "-", Year)

The Year column is a Choice data type, and when I use this formula, it concatenates the numeric value of the year instead of the label (e.g., it adds 1 instead of "2024").

How can I modify the formula to use the label (display text) of the Year choice column instead of the internal numeric value?

Categories:

General Questions

Using Apps Using Formulas

All responses (1)

Answers (0)

Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (1)

Report
Issue with Concatenating Choice Column Label Instead of Value in Power Apps

Hi priya_,

Do you have this Label in a gallery? If yes, can you try using the below and see if it solves your issue?

Concatenate(ThisItem.'Registration Number', "-", First(ThisItem.Year).Value)

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!