Virtual Column to Format Enum List as Text String

[Mel]

Hi all. I'm working on an app with an automation that creates and emails a document. My business requirements include allowing a field on the application to have multiple selections (which is solvable with an EnumList). This field needs to show up on the document with commas after each value, the word "and" before the last value, and no comma after the last value (e.g. "John Brown, David Smith, and Susan Moore.")

My first thought was to create a virtual column to format this column into a text string, by using TEXT(). However, I'm not sure how exactly to build this expression to meet my needs. Looking for help on this expression or a better way of solving this issue. Thanks!

[Marc_Dillon · Accepted solution]

TEXT( TOP( [enumlist] , COUNT([enumlist)-1 ) ) & ", and " & INDEX( [enumlist] , COUNT([enumlist]) )