Concat() stopped working when I changed from internal list to SharePoint

Hey,

I recently had some help with getting a combobox to list its selected items as "X, Y and Z". I had this bit of code listed for me, but I've since changed from a manual list of items to a SharePoint list. After this change, it gives me an error line under the entire formula. I'm assuming Concat can't work for a single column list? Services is the name of my list in SharePoint, and all of my items are listed in the Title column. I've been staring at this for days and tweaking, does anyone know how to fix this up?

With(
{ListLength: CountRows(Services)},
If(
ListLength > 1,
Concat(
FirstN(
Services,
ListLength - 1
),
Value,
", "
) & " and " & Last(Services).Value,
First(Services).Value
)

Categories:

Connectors

General Questions