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)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.