Power Platform Community Forum Thread Details

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:

Building Power Apps