Max Melcher

3 minute read

Whats the story post Infopath and how to build business apps with PowerApps? – in this session Chris McNulty (@cmcnulty2000) and  Kerem Yuceturk will tell us!

No-code and low-code applications have been essential tools in Microsoft SharePoint for a long time, but we’ve added many other new tools to your palette. We review the roadmap and best practices for InfoPath, SharePoint Designer, Access Web Apps, Flow, PowerApps and more.

Start with a demo!

Always good to start with a demo – in this case Kerem started with a “vacation request” application that I have seen a couple of time in my career, too – but this time with PowerApps on a cell phone.

So we saw Corporate Design with a Logo and style, date pickers, text fields, a calculated field that shows the amount of days between the selected days – once submitted the status field (no visible from the edit form) was set and submitted to a SharePoint list. So that one triggered a Microsoft Flow to send out a simple approval mail to approve/reject the request.


Basic stuff – but a very promising start of this session!

Microsoft Forms

EDU only, no integration to SharePoint, no designer.



Connect to onPrem data via a bridge that relays your requests. In that way you can access and store data to SharePoint 20132016 onPrem.



Interact with tons of services from Twitter, SalesForce, SharePoint or simple stuff like sending emails. Dozens of templates are already available:


PowerApps Designer

The designer is a browser based (Chrome shown) to create forms.

When the PowerApp designer is started, 3 views aka screens (Browse, Edit, Details) will be created with all the fields that are existing. As of now you cannot create new fields because the SharePoint list is the master. Drag and Drop of controls, realignment – everything is there.

Search Control: You can bind a complex expression to it similar to what is possible in Excel. Here a filter condition was shown to only return items of the current user. There is an autocomplete feature for the expressions.

Controls: We saw textboxes, calendars with binding to different datasources.

Expressions & Binding: That looks powerful. You can even combine expressions like “open new form, then go to a view”.

Conditional formatting: Done with expressions

External validation & logic: Currently Azure Functions or webservices are possible. NO CODE-BEHIND and thats AWESOME.


Flow Designer

After setting up the form, Kerem added a simple workflow.


There are auto completes available if the action needs inputs e.g. from the submitted list item.

Connections: Interesting concept to link to onPrem environments through gateways. Need to fiddle with that.

Pricing & Licensing



More controls for images and attachments – multi-value fields

Flow integration for OneDrive and Document libraries

adhoc start for selected items

Embedding of PowerApps in new SharePoint pages


GA date is not yet available:


Further notes

Because I attended a theater session about that and crawled through the expo, I asked the experts addtional questions:

Multi Language support: is on the roadmap, implementation details were not exposed but it sounded almost like resource files.

Repeating fields: is on the roadmap. Apparently my question how the repeating data is stored in the list was not answered.


The expectations for the business applications on top of SharePoint are highest! The business productivity part of SharePoint is what made the platform so great and we need to see a modern solution for forms, requests and all the business needs.

This session was a great start that gave me confidence that PowerApps could be a great successor for Infopath – and luckily they do not try to seek feature parity with Infopath!

Cool stuff, watch the session once its online!

comments powered by Disqus