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!
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 2013/2016 onPrem.
Interact with tons of services from Twitter, SalesForce, SharePoint or simple stuff like sending emails. Dozens of templates are already available:
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.
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:
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!
Max’s free time is spent on twitter (@maxmelcher) mostly with a good coffee in his hands.
Latest posts by Max Melcher (see all)
- 3x Office 365 Developer Bootcamps: Munich, Berlin and Hamburg! - October 3, 2017
- PowerShell: Upload a CSV file to a SharePoint List - September 11, 2017
- How about building a magic mirror?! - March 25, 2017