
Announcements
Hi everyone,
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?
Concatenate(ThisItem.'Registration Number', "-", First(ThisItem.Year).Value)