Feb 27 2020 04:58 PM
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
Feb 27 2020 07:38 PM
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/