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

(0) 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 370 on at

Like (0)

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!