Migrating from InfoPath to Power Apps

Migrating from InfoPath to Power Apps

Posted by Kristina Rosario | May 15, 2019 | Blog

Included in an active Office 365 ProPlus subscription, InfoPath is a tool that lets you create forms and gather data in order to streamline your business processes. InfoPath also requires no code, and developers can create advanced forms as well—including composite applications and workflow sequences.

PowerApps is a suite of apps, services, connectors and data platform that provides a quick way to build custom apps for your business needs. These apps connect to your business data stored both in the underlying data platform or in various online and on-premises data sources (SharePoint, Excel, Office 365, Dynamics 365, SQL Server, and so on).

All apps built with PowerApps require no code, have a responsive design, and can run in any browser—including mobile.

Great! Can I migrate from InfoPath directly into PowerApps?

Unfortunately, no. Everything you have in InfoPath forms will have to be remade from scratch in PowerApps. Below is a Microsoft Ignite session that will help you get started.

So does PowerApps do everything InfoPath did?

Also, no. PowerApps still has some limitations that keep it from fully replacing InfoPath—hence the InfoPath support until 2026, as Microsoft needs time to keep adding features that will allow PowerApps to do so.

What do they have in common?

In terms of desktop clients, both InfoPath Forms and PowerApps have desktop clients, with InfoPath’s support ending in 2026. Both can be used to create Apps for the web, but PowerApps has more limitations at the moment.

In mobile support, while InfoPath lets you design templates for Mobile, these have to be custom-made. PowerApps, on the other hand, offers native creation of mobile apps—which can be later installed on mobile devices, be it cell-phones or tablets.

Both InfoPath and PowerApps have the drag and drop functionality to attach and drag SharePoint List items from one column to another. PowerApps has this simplified, however, and it’s easier to drag and drop items in order to increase visual interest in your forms.

InfoPath lets you connect to many external sources to display data on a form, and so does PowerApps through the use of Connectors.

Offline capability is also offered on both services. This enables users with limited network capabilities to fill out template-based forms based on the Offline template. While InfoPath will let you configure a form’s template to cache data locally, PowerApps enables local collections for data management without changing the app.

What does InfoPath have that PowerApps doesn’t?

Custom Code is where InfoPath still has the upper hand, as it lets you create templates that have business logic coded in C# or VB. PowerApps does this all without enabling managed code, which does limit the most advanced options.

Another aspect where InfoPath is ahead is external user autonomy. InfoPath lets anonymous users submit data to a SharePoint list, whereas this capability isn’t available in PowerApps yet.

Finally, there’s the matter of XML as a data source. InfoPath lets you design and create forms that deal with structured XML documents—but this isn’t supported by PowerApps yet.

What’s easier to do on PowerApps?

Adding conditional logic to your forms, for instance. Although InfoPath lets you do this, PowerApps does that, and more. Not only does it let you show/hide columns, you can also change colors, spacing, etc. While the controls aren’t quite the same, Microsoft will keep on working to make logic within PowerApps easier, and once you learn how to add conditionals, it’s extremely simple to do it again.

It’s also very easy to use PowerApps with SharePoint on-premises if you’ve been assigned a license. You can then install the “On-Prem Gateway” on your SharePoint and use it to access all your information in SharePoint.

PowerApps can also replace your normal SharePoint list form. It is, however, only enabled in the “Modern” SharePoint experience. If you’re using Modern for lists, all you have to do is go to your List Settings, then Form Settings, and choose “Use a custom form in PowerApps.” After you customize that PowerApps form, it will automatically save back to the list. This lets you have new and customized view/edit forms just like InfoPath.

What should I do?

Although you still have a few years to use InfoPath, the app will no longer be supported after 2026. You can still use InfoPath until then, of course, but the sooner you begin moving to its replacement, PowerApps, the better.

It sounds daunting, but with PowerApps’ new tools, you can transform your basic InfoPath form into an efficient one with PowerApps to greatly streamline your processes.

Related Blogs

Posted by microsoft-admin | May 22, 2019
1. Use of Agile/Quick Approach to Development Among development approaches, the most popular ones are the Waterfall and Agile. While Waterfall worked pretty well when computers were a new technology,...
Posted by microsoft-admin | May 8, 2019
Last week, we began to take a look at both Modern and Classic UIs for SharePoint and see whether you should make the jump. Today, we continue the conversation. Team...
Posted by microsoft-admin | May 2, 2019
With the advent of the Modern UI for SharePoint, is it worth fully migrating to the new version? Today we’ll take a look at both Modern and Classic UIs for...