Combine all values of one collum / rows of a collection

[LH]

Hi folks, me again.

I have a collection like this:

First          Last           City

Peter        Smith        Munich

Paul         Miller        Hamburg    

Marry       Kruger      New York

I am searching for a way to combine all values in (e.g.) "First" into a multiline textbox

The result sould be like:

Peter

Paul

Marry

How can i manage this?

Regards Lars

[yashag2255 · Accepted solution]

Hey @LH 

You can use the below expression in the text property of the label:

Concat(CollectionName,First,Char(13))

[v-xida-msft]

Hi @LH ，

Could you please share a bit more about your scenario?

Do you want to combine all values from "First" into a multiline textbox?

I have made a test on my side, please take a try with the following workaround:

Set the Default property fo the Text Input box to following:

Concat('20190701_case7', Title & Char(10))

On your side, you may need to type the following formula:

Concat('YourCollection', First & Char(10))

Please take a try with above solution, then check if the issue is solved.

Best regards,