SharePoint & InfoPath get values of a multi choice field

In one of my projects i had a form in which i am fetching data from a second list. In this second list there is a people field in which user can insert one or more people. And exactly these values should be displayed in my form. I tried a computed field, a textfield, a people field, but it only displayed the first value cause i choosed the displayname of the people field. If i select the people group it displayed everything (displayname, Userid and type).

So i googled and found this script and put it into my textfield:



eval(eval(DisplayName[ID = LookupFieldInMyForm]; 'concat(., ";")'); "..")


What does it do?

Well, in short it put each value of the people field from the second list and after each value it adds “;”. That was exactly what i needed.

If you want to use it for a listview box and you only want to extract the selected items you have to modify this part:

DisplayName[ID = LookupFieldInMyForm]

This it is reading the values.

I hope it helps you.

..:: I LIKE SHAREPOINT ::..

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.

Karsten Pohnke About Karsten Pohnke
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

Submit comment

Allowed HTML tags: <a href="http://google.com">google</a> <strong>bold</strong> <em>emphasized</em> <code>code</code> <blockquote>
quote
</blockquote>

Please fill in the captcha: * Time limit is exhausted. Please reload CAPTCHA.