web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Issue with Concatenati...

Power Apps

Suggested Answer

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

(1) Share

Report

Report

Posted on by priya_

8

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No

Join the conversation