Concatenate from List

[Taylor_Lewis]

So you can “SPLIT()” a structured text based list. Can you “CONCATENATE()” from a list?

I want to display values in a single virtual text field from a “SELECT()” list of values. Can I aggregate values from a list into a single test field?

[Steve]

Sure!

[Taylor_Lewis]

Cool, thanks. I was looking for some type of delimiter selection on the concatenate side to make it work, but I guess it is unnecessary. Should’ve just tried it. Thanks anyway.

[VBBA]

I am looking for exactly this function to convert multiple items from a different table into displaying in a virtual text column.

However, appsheet seems to only convert one random value from the list:

Ideally I would like to convert all values, delimited by “,”. Is there a way to do this?

[VBBA]

It works when I use this expression in the formula:

CONCATENATE(SELECT(ServicetoTech[TechID], [_THISROW].[ServiceID]=[ServiceID]))

[Rafael_ANEIC-PY]

Hello @VBBA , that is because VLOOKUP() only returns a single value given the search criteria, while SELECT() would pull a filtered list, which is then concatenated.