Dear InfoPath, it’s time to say goodbye…

Now it is official. InfoPath client and form services in SharePoint will be retired. In many posts there were already questions about what’s going on with the form technology from Microsoft. Microsoft posted today in this blog about the future of InfoPath and form technology.

The key facts:

  • InfoPath client 2013 is the last published version
  • InfoPath Form Services are the last time published with SharePoint 2013
  • Support will go on till 2023
  • Microsoft recommends to use InfoPath further on
  • Microsoft will bring updates in the current year about new form technology and migration plans
  • Microsoft says it might be that SharePoint, Access and Word will be the next form technology

At the SharePoint Conference in March, Microsoft will announce some news on this topic:

If you’re attending the SharePoint Conference in March, you can get a sneak peek of what we’re building in “InfoPath and SharePoint Forms Roadmap” session.

The session should be available afterwards online. I think you’ll find it here.

Bye bye, InfoPath –  we had good days and bad days.

And what now? Continue reading

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.


SharePoint & Office 2010 Service Pack 2

Microsoft officially and proudly announced the second Service Pack for Office 2010 and SharePoint 2010 a few days ago.

Included in this Update are all cumulative Updates as well as public updates after SP 1. This Service Pack 2 should remove some bugs and should improve the security and performance. It also improves working with IE 10, Windows 8

Download it from here:


  • Improved support for Internet Explorer 9.
  • Recycle bin: Lets you restore a site collection or a web that was deleted.
  • Remote Backup Systems (RBS) and shallow copy can decrease downtime and increase efficiency by moving pointers to databases instead of moving databases.
  • You can see which folders are taking up valuable space with the improved Storage Management feature in site settings.
  • Support for Microsoft SQL Server 2012.
  • A more robust Search Host Distribution service that improves error recovery and performance during the search crawl.
  • Adds backup and restore functionality to recover deleted site collections and webs.


On the page there is also an issue list which issues should be removed.

I didn’t installed it yet, so please do not install it on a production system before you didn’t test it on your dev and staging system.


InfoPath Fill or empty a repeating table in browser-based form by using code-behind

InfoPath is a powerful tool which can be customized by using rules or custom code behind. At one of my projects it was necessary to display some additional information from a database dependent on which checkbox the user clicked / checked. Another request to this was that the form has to be browser-enabled cause it should be displayed in a SharePoint environment.

So i have 3 Checkboxes: A, B, C. And i have a section with a repeating table which is structured like this:

I use the onchange Event of each Checkbox which calls the function. Now let’s see how we can fill this repeating table with data: Continue reading