by spjeff

Form Library JS – an InfoPath replacement?

July 30, 2014 by spjeff

Microsoft announced InfoPath will go away in 2023.  It makes sense and they have good reasons.   However, form developers are confused about available options.  I have an idea for the InfoPath Roadmap and would appreciate your feedback in the comments below or Twitter (@spjeff) please.

Why not use JavaScript to create similar XML documents?

When people say “InfoPath” they generally are referring to a three part system outlined below.   InfoPath strictly speaking is the form input experience.  Form Library holds the saved XML output.  SharePoint Designer can then trigger email notifications based on status change.



InfoPath as a form input experience has many limitations based on the server postback and Dot Net architecture.  Just try a large repeating table and watch the slow “Loading…” experience as users click and rules postback to the SharePoint IFS backend.   HTML5 and JavaScript offer new options for client side validation, async loading, mobile touch input, responsive layout, and advanced rendering with framworks like JQueryUI  / Bootstrap / Angular.   That’s awesome form input technology!    However, InfoPath is normally chosen for ease of use and “no code”.   Let’s think about how that conversation might go …

Developer Conversation

DEV1 >  “Hey did you hear Microsoft is retiring InfoPath in 2023?”

DEV2 >  “Yeah, but it’s all we have today so I’ll keep using it.  Not sure what else to use.  Sure would be nice to have HTML5 and cooler input experience.”

DEV1 > “Definitely.  Coding from scratch is a lot of work.  I don’t really want to mess around with SPList REST connections for CRUD or make a SQL database with SVC/OData for simple forms.  My head hurts.”

DEV2>  “True, but I guess we’ll gave to make a schema first then form later.”

DEV1 > “InfoPath saved as XML.   I like XML.  It works well for import/export across all of our systems.   Could we keep XML but ditch InfoPath?”

DEV2 > “Cool idea, but I’m not sure how.”

Why throw out the baby with the bathwater?   


Can’t we make fantastic forms with HTML5/JS and then save back to a Form Library in order to leverage SharePoint for storage, views, and workflow?    Right now this is just an idea.  I don’t yet have a working prototype to show but think it would be straightforward to convert JSON to XML and upload.     InfoPath would still be used but by developers for schema only (define XML structure).   End users would never see it.


Please leave a comment below and let me know if you think this might be practical.  Thanks!   Smile





by spjeff

My first Angular app – Todo List

June 11, 2014 by spjeff

Recently I began studying Angular as a JavaScript framework to accelerate front end development.  SharePoint 2013 app model is obviously a place where this could be helpful and the community started as a launch pad for future content.

Below is a quick 10 minute video of me coding a Todo List with Angular and Visual Studio 2013 based on the JS Fiddle example    Hopefully this walkthrough shows just how quick and simple Angular can be.  Intellisence from Visual Studio and Viasfora “rainbow brackets” make the coding even easier.   Enjoy!  Smile




For a good read on Angular concepts check out O’Reilly at

by spjeff

SQL Server 2012 Service Pack 2

June 11, 2014 by spjeff

Today I noticed a bunch of new Microsoft Downloads posted on that RSS feed for various components within SQL Server 2012.   Service Pack 2 is now out and each component has a new download available.   These can be helpful for anyone working on Business Intelligence projects with SharePoint 2013.  Links below.  Enjoy!  Smile


SQL Server 2012 SP2 = 11.00.5058.0

Microsoft® SQL Server® 2012 Service Pack 2 (SP2)

Microsoft® SQL Server® 2012 SP2 Report Builder

Microsoft® SQL Server® 2012 SP2 Reporting Services Add-in for Microsoft® SharePoint®

Microsoft® SQL Server® 2012 SP2 PowerPivot® for Microsoft SharePoint 2013®

Microsoft® SQL Server® 2012 Service Pack 2 (SP2) Master Data Services Add-in For Microsoft® Excel®

Microsoft® SQL Server® 2012 SP2 PowerPivot for Microsoft Excel® 2010

Microsoft® SQL Server® 2012 SP2 Semantic Language Statistics

Return to Top ▲Return to Top ▲