Forum Discussion

Ken_Ptx's avatar
Ken_Ptx
Copper Contributor
Feb 28, 2020

Concatenate multiple selections into one text

I need to concatenate a multiple choice column in SharePoint Online List into a single text as calculated column.

Example:  If user selects "Shift A"  and "Shift B",   The calculated column will have "Worked on Shift A and Shift B" as single line text.

If user selects "Shift B"  and "Shift C",   The calculated column will have "Worked on Shift B and Shift C"  as single line text.

  

I have been searching on the web for the last 3 hrs. without success.  Anyone has a good trick to do that?  Much appreciated.      Thanks

SharePoint Online

1 Reply

  • O365Developer's avatar
    O365Developer
    Brass Contributor
    Feb 28, 2020

    Ken_Ptx 

     

    MultiSelected Choice field doesn`t support Calculated column and it doesn`t list the column to add it to formula of Calculated column

     

    This applies to SharePoint Online and On-Prem.

     

    We need to implement a remote event receiver 

    https://www.tatvasoft.com.au/blog/how-to-implement-remote-event-receiver-in-sharepoint-online/

     

     

Resources