Using PowerApps to Build SharePoint List Forms

Today Microsoft announced the next step for PowerApps integration with SharePoint – using PowerApps forms within the context of a SharePoint list or library.

This is another way PowerApps is becoming a strong successor to InfoPath forms and will give your users a rich viewing, creating, and editing experience right within their SharePoint library or list.

Using a PowerApps Form to View, Create, and Edit SharePoint List Items

This feature will be coming to SharePoint Online & Office 365 this Summer and I expect we will immediately start using the functionality within my client organizations to improve the user experience.

I highly recommend watching the new Microsoft Mechanics video “Zero code business process apps in SharePoint with PowerApps and Microsoft Flow” to get an idea on how the forms will be created and used.

Microsoft Stream General Availability

Yesterday Microsoft announced via a message (MC101855) in the Office 365 message center that Microsoft Stream will be generally available soon.

A few months ago, a preview of Stream was announced and you can view more information about the service on the Microsoft’s site. The service will be on by default now and will be visible in the Office 365 app launcher.

If you are using Office 365 Video to serve content within your organization, there is nothing you need to do at this time. The move to Microsoft Video will be a phased approach and Microsoft has promised that the move will include all your content and metadata.

After the transition, existing Office 365 Video embed codes and links to videos will still work, redirecting to the same content in Stream.

The full message can be viewed within your Office 365 tenant’s message center.

[UPDATE]
Originally, this post made reference to Microsoft Stream being available now. Stream will be generally available soon and another announcement will be made when it is out of preview. Sorry for any confusion the original post may have caused.

Creating & Upgrading SharePoint Workflows – April 9th 2017

I am excited to be speaking once again at the Nashville SharePoint Users Group. The meeting on May 9th 2017 is in-person and via online meeting and the topic is “Creating & Upgrading SharePoint Workflows”. The details of my presentation are below.

For a long time, we have used workflow for automating business processes in every version of SharePoint, while using various tools to create them: out of the box workflows, SharePoint Designer, Visual Studio, & third-party applications like Nintex and K2.

  • Now that SharePoint Designer will no longer updated and there is a push to move to the cloud, what are we supposed to do now to automate tasks and business workflow?
  • What if you aren’t moving to Office 365 and just want to know what tool you should use to create workflows moving forward?
  • Should you migrate your existing SharePoint Designer workflows to Microsoft Flow or a third-party tool? What would that process look like?
  • Should you continue to build workflows using SharePoint Designer in SharePoint 2010, 2013, 2016?In our time together, we will review those questions and more so you can be confident in your path forward with process automation, no matter what version of SharePoint you are using or where it is hosted!

[UPDATE]
I had a great time with the group tonight. There were some great conversation concerning the gaps between SharePoint Designer workflows and Microsoft Flow. Everyone stay tuned to this space and make sure you register for the May 16th Microsoft Virtual Summit.

SQL Saturday Pensacola 2017

Join me on June 3rd at SQL Saturday Pensacola! I will be teaching the Keys to Successful SharePoint Administration for DBAs and if you are in town I would love for you to attend my session.

Registration is open now! SQLSat Pensacola Info

Music City Code 2017

The Music City Code conference is once again taking place in Nashville and I am excited to be speaking! I was part of a community panel for the 2016 event, and this year I am giving a presentation on using Power BI to bring dashboards to SharePoint.

My first session will be Jun 2nd at 9:30am in room Rand 306. I will also be joining Lisa Anderson’s session as part of a Microsoft MVP panel at 2:40pm on Jun 2nd in room Alumni Classroom 201. Hope to see you at both sessions!

The event runs from June 1-3 – registration is now open! Music City Code Info

[UPDATE]

Thank you everyone who came attended my morning session & joined the MVP discussion. Music City Code is a fantastic event and the attendees were awesome!

SharePoint Dashboards using Power BI – Nashville Excel & Power BI User Group

I am presenting at the Nashville Modern Excel user group on April 13, 2017 – come join us! My talk will focus on using SharePoint to build business intelligence dashboards with Power BI and Excel.

Register on the user group site: Nashville Excel & Power BI User Group

[UPDATE]
Thank you to everyone who attended my presentation – what a great group!

It May Be Time to Stop Building Access Web Apps

For years now, power users have created solutions using Access Services within SharePoint. These solutions have often been the backbone of many business processes for small to medium-sized organizations. Now that Office 365 is widely available and is fairly cost-effective for those organizations, we have new options to solve those business needs.

Microsoft PowerApps is a new member of the Office 365 family and now that PowerApps is generally available within Office 365, Microsoft is recommending to organizations that solutions built with Access Services be migrated to the PowerApps service.

Access Services & Access Web Apps shipped with SharePoint 2016 and will continue being supported as part of the SharePoint product life-cycle.

Moving forward, information workers should build their apps using PowerApps on top of SharePoint lists to give the feature-rich solutions their users need with the full on-going support of Microsoft and the tech community.