Calculated column that concatenates a Choice column

(0) Share

Report

Posted on by AliceW

286

Hello everyone,

I want to create a Formula column that concatenates two columns, one of which is a choice one.

I've tried adding the dot after the name, but I don't want to include only one value.
'Year (Tree)'.2025.

It has to concatenate regardless of the year chosen.

Please help :)

Categories:

Tables

Microsoft Dataverse

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

developerAJ 4,611 on at

Like (1)

Report

Calculated column that concatenates a Choice column

Concatenate(Title,"-",Switch(choice,'choice (child1S)'.a,"a",'choice (child1S)'.b,"b"))

assume choice as column name and child1s as my table you need to define it this way

1 people found this reply helpful.

Was this reply helpful? Yes No
AliceW 286 on at

Like (0)

Report

Calculated column that concatenates a Choice column

Thank you, AJ!

Was this reply helpful? Yes No