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.
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;
";")