Reputation: 525
I have a dropdown list bound to a User/Group type field of a SharePoint list. I can select multiple users and would like to collect their email address.
I expected that this would work. My delimiter is ;
, that is correct.
Concat(lsOwner.SelectedItems.DisplayName; ";")
The problem is that this returns only empty strings. I have 2 users selected, and the result is ;;
.
To check, if the values present, I mapped the result to a listbox and there I can see the 2 mail addresses.
Just to be curious, I tried to collect the addresses from the listbox like:
Concat(ListBox1.SelectedItems.Value ;"")
Concat(ListBox1.SelectedItems.Email ;"")
Both of them returned empty strings (even tough the email address were visible in the list), when I selected one or more. Please, somebody tell me what do I do wrong. Thanks in advance.
Upvotes: 2
Views: 6996
Reputation: 87228
The second parameter of the Concat function is the expression that will be applied to the records of the first parameter. What you want is likely the following expression:
Concat(
lsOwner.SelectedItems;
DisplayName;
";")
Upvotes: 2