Home

Concatenate multiple selections into one text

%3CLINGO-SUB%20id%3D%22lingo-sub-1199708%22%20slang%3D%22en-US%22%3EConcatenate%20multiple%20selections%20into%20one%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1199708%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20concatenate%20a%20multiple%20choice%20column%20in%20SharePoint%20Online%20List%20into%20a%20single%20text%20as%20calculated%20column.%3C%2FP%3E%3CP%3EExample%3A%26nbsp%3B%20If%20user%20selects%20%22Shift%20A%22%26nbsp%3B%20and%20%22Shift%20B%22%2C%26nbsp%3B%20%26nbsp%3BThe%20calculated%20column%20will%20have%20%22Worked%20on%20Shift%20A%20and%20Shift%20B%22%20as%20single%20line%20text.%3C%2FP%3E%3CP%3EIf%20user%20selects%20%22Shift%20B%22%26nbsp%3B%20and%20%22Shift%20C%22%2C%26nbsp%3B%20%26nbsp%3BThe%20calculated%20column%20will%20have%20%22Worked%20on%20Shift%20B%20and%20Shift%20C%22%26nbsp%3B%20as%20single%20line%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20searching%20on%20the%20web%20for%20the%20last%203%20hrs.%20without%20success.%26nbsp%3B%20Anyone%20has%20a%20good%20trick%20to%20do%20that%3F%26nbsp%3B%20Much%20appreciated.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1199708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1199836%22%20slang%3D%22en-US%22%3ERe%3A%20Concatenate%20multiple%20selections%20into%20one%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1199836%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570131%22%20target%3D%22_blank%22%3E%40Ken_Ptx%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMultiSelected%20Choice%20field%20doesn%60t%20support%20Calculated%20column%20and%20it%20doesn%60t%20list%20the%20column%20to%20add%20it%20to%20formula%20of%20Calculated%20column%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20applies%20to%20SharePoint%20Online%20and%20On-Prem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20to%20implement%20a%20remote%20event%20receiver%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.tatvasoft.com.au%2Fblog%2Fhow-to-implement-remote-event-receiver-in-sharepoint-online%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tatvasoft.com.au%2Fblog%2Fhow-to-implement-remote-event-receiver-in-sharepoint-online%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

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

1 Reply
Highlighted

@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/