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!
Solved! Go to 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
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
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
You're Welcome 🙂