Concating a few combobox values into text field

[Anonymous]

Hi All,

I have a multiselect combobox with Users list as a data source. I would like to concat/concatenate a multiple selected values into a text field and have the following information of the selected users: Users Name, Position, Department.

With concat function I am able to do it with one value, but cannot get it to work with multiple values. I would ideally like to avoid creating a collection for selected items.

Any suggestions are greatly appreciated!

[phipps0218]

I suggest a collection and use AddColumns function.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

[NandiniBhagya20 · Accepted solution]

Hi,

You can use below formula.

I have used Email and DisplayName properties from user combobox for testing purpose -

Concat(DataCardValue33.SelectedItems, Concatenate("Email: " & Email & " Name:" & DisplayName), ", ")

DataCardValue33 is user comboxbox 

[Anonymous]

Thank you @NandiniBhagya20, this was exactly what I needed!

[NandiniBhagya20]

You're Welcome 🙂