Forum Discussion
Enabling InfoPath for SharePoint Online
I would keep an open mind at the moment. We are in a similar position and have InfoPath fully integrated into critical business systems in Office365. We have been carefully monitoring the situation.
To be honest there is nothing out there (despite claims to the contrary) that can fully replace InfoPath and I presume this is one reason why Microsoft have slowed down its demise. (It has been included in SharePoint Server 2019). PowerApps and Flow are not there yet.
Our policy is to replace InfoPath and we are doing this gradually. Wherever possible we are migrating to SharePoint Lists and have been successful in using Skybow to develop forms and Qdabra Form Viewer as a disaster recovery solution..
I must admit, the uncertainty around InfoPath has been extremely disruptive and Microsoft have failed miserably in handling this well with it's client base.
I totally agree with your thinking Steve, and the pragmatic approach you have taken to move things forward.
There are many companies who over many years have invested in developing with InfoPath (and some who still do) and a message of 'PowerApps is the replacement for all' is not entirely helpful to them or in my opinion the whole truth. It saddens me that the extended usefulness of InfoPath as a product has not been recognised, and let's be generous here and say that perhaps Microsoft and other influencers who suggest only using PowerApps haven’t used InfoPath to any depth.
I’ve developed many solutions with InfoPath and some with PowerApps, and if you are looking at the current functionality, I would judge that it can only do 50% of that which InfoPath 2013 can do - and it requires a far greater level of Developer involvement to reach that far. It also requires Flow to be used to cover certain workflow aspects as well. I do admit that it is a technology which is old, deemed out of date, is a bit clunky and is not great at all from a server perspective, but that's because there has been no real active development of it for more than 5 years.
To my mind that results in a real problem; knowing that which can be achieved with InfoPath and comparing it with that which can be achieved with PowerApps, which solution should a Company opt to use? Undoubtedly over time the PowerApps functional capability will improve, however Microsoft have already spent 3++ years developing PowerApps and it has no where near the level of capability it needs to replace technical InfoPath forms. How long Microsoft will need to increase the functionality to 75% is anyone’s guess. It’s also very obvious that its whole bias is the mobile & tablet focus which just doesn’t cut it if you need forms of a complex and highly capable nature to reflect some Processes of a business.
If you can use PowerApps to replace the simpler instances of InfoPath design then I strongly encourage people to do that. But I also strongly encourage people to seriously look at the complexity and awkwardness of pushing the design capability of PowerApps too far (at the moment), and then having to un-pick/re-design/re-develop that as new features appear (or don’t).
The only natural framework I’ve come across which picks up the InfoPath development effort already invested by companies and takes that as it is, are the Qdabra products. They are the ultimate progressive up-grade path for InfoPath forms ensuring that anything of a technically competent nature has a way of being supported – it’s like proceeding down a street which has a sign-posted as ‘No Exit’ and discovering a cut through to take you back to the main road!
I also concur Steve with your uncertainty comment – Microsoft have really messed up with this one big time.
Alan C.
- Dec 03, 2018
One important thing to consider is that we're talking about SharePoint Online, so whilst InfoPath will continue to be a supported product until 2026, including support in the on-premises versions of SharePoint Server, that doesn't mean it will continue to be supported in SharePoint Online for the same period.
Any feature can be withdrawn from SharePoint Online at any time with the requisite notice which I believe is One Year. Any organisation banking on the availability of InfoPath for a developed solution needs to ensure that they understand the risk and the potential cost if they have to rebuild that solution in a reduced timescale.
That doesn't mean MS are going to pull the product early, but you have to allow for the fact that if it makes commercial sense they can, and you should plan accordingly.
- Alan CourtenayDec 03, 2018Brass Contributor
I understand and fully appreciate that the Forms Services element of SharePoint Online (to run InfoPath browser forms) could be pulled my Microsoft at any point, and that is why to me the FormsViewer functionality as provided by Qdabra is the ‘get out of jail (almost) free’ element in the process as far as I am concerned. (I must point out here I am not a Qdabra employee but I am someone who has been looked at many options and am convinced of the approach they have taken with their products.)
Knowing that at any time I can continue to use an InfoPath template form via the FormsViewer capability (in crude terms it takes the place of the Forms Server functionality on the server) takes the pressure off entirely. The code can be installed in-house if need be if security or governance needs require that, however the web version works with both Office 365 or in-house usage. Very importantly it doesn’t store the outcomes – the records /XML files online, just a copy of the design template needs to be uploaded.
Why I've been so convinced about this approach is that the FormsViewer framework means there is no application rebuild process to have to consider at all as native XSN templates can be upload, tested and trialled and then brought directly into production either to parallel run or on simple switch over. Again importantly the existing documents and all future records (XML files and meta data) remain in the same SharePoint library and site so there is absolutely minimal effort and cost when switching over.
To expand my position a bit more, I’m not saying that continuing use of InfoPath is ultimately a sensible long term decision to make, rather I am saying use it while we can, plan to ensure you can still use it in the future (using the FormsViewer capability), and then ultimately look to migrate to a new Business Application (in whatever solution framework actually meets the need for that application - including looking at PowerApps) when it becomes appropriate to do so from a BUSINESS perspective – i.e. when the business needs alter or change. At the same time if InfoPath is no longer fitting the bill or can be supported, or if Microsoft pull the plug on the Forms Server element of SharePoint, then those also become points to ask ‘Do we change’ questions.
As you can guess from the bit of a rant up above, I really like InfoPath and consider there is nothing at the moment that comes close in the Microsoft stack to replace it. From what I’ve seen happen with PowerApps over the past year or so I unfortunately doubt I shall change that position in the coming year either. I wish that wasn’t the case and Microsoft had announced a really excellent replacement with BOTH mobile & tablet AND desktop application capability – but they haven’t.
As such I’m trying to make the best of a bad job, trying to ensure that people think twice before they spend vast sums on rebuilding perfectly good applications (for the moment) which were developed in InfoPath, and to encourage businesses to extract as much value as they can from their investment.
Sorry – I’ll get off my soapbox now! Regards Alan C.
- IndyColtsFanDec 11, 2018Copper Contributor
I know I'm a little late to the thread, but I wanted to chime in and say I agree 100% with Alan and Steve. I've worked with InfoPath for over a decade and have built some ridiculously complex forms. I know I haven't been working with PowerApps nearly as long, but from my experience so far, it isn't there by any stretch of the imagination. Complex forms with massive amounts of custom logic and conditional formatting are relatively straightforward to implement in InfoPath but are very difficult, and in some cases impossible, to completely implement in PowerApps given the display limitations (lack of real estate, lack of sections, lack of repeating tables, lack of real control over layout, etc). Now, maybe my list is wrong and maybe I'm overlooking some capabilities of PowerApps since I'm still fairly new (at least, I HOPE that's the case), but it sure seems to me that Microsoft has really done a poor job on guidance regarding what to do with the impending demise of InfoPath.
Also, thanks for the pointer on Qdabra - I'd heard of it but hadn't done a deep dive yet, but you can bet I will. :)