Introducing Column Formatter

June 6, 2018
Posted in IPI BLOG
June 6, 2018 Esther Wilson

As we are aware Microsoft 365 keeps driving digital transformation to increase productivity and strengthen business growth, giving organizations the opportunity to accelerate and optimize business processes. Today, we are announcing a new series of capabilities for SharePoint and OneDrive, integrated with PowerApps, Power BI, Microsoft Flow and Microsoft Forms, that allows people to create and share custom forms, applications, and workflows that automate processes.

Microsoft Forms allows anyone to create surveys and simple forms inside and outside organizational boundaries.  Custom forms with PowerApps and column formatting allow a designer to build beautiful experiences for multiple data sources or just a single field.  Mobile interfaces for PowerApps and Flow can now be shared in the browser views for SharePoint sites for a more consistent user experience. Power BI is integrating new capabilities for generating reports from data wherever it lives.  And SharePoint lists are being optimized with predictive indexing to accelerate lists with millions of items.

Work with the largest lists and libraries with predictive indexing and queries:

SharePoint lists have long been used for planning, tracking, collaboration and data management.  They’re used to track everything from t-shirts and lunch orders to NASCAR race standings and public health programs.  Up to 30 million items can be kept in a SharePoint list.  But until recently, storing more than a few thousand items required careful planning and administration.

Predictive indexing changes that.  As lists grow beyond 5000 items, SharePoint senses the fields used in views and sorts and automatically adds indexes without user intervention or throttles.  The modern user experience is also optimized to use those indexes, when available – and to retrieve data in sets to avoid throttles and unavailability.

 Visualizing column data with column Formatter

SharePoint lists can be tailored to support almost any content or business application need.  But until recently it has required special skills custom development to customize the formatting of fields and columns.

Today, Microsoft is introducing new, low-code capabilities that open custom formatting to non-developers too.   Data bar graphs, color coding, red-yellow-green KPI icons, or interactive icons for email and Flow can be easily added to any list or library.

Advantages of the Column Formatter.

The column formatter lets people cut-and-paste JSON formatting scripts from our SharePoint Patterns and Practices site as column properties.  As announced, there would be a change to make SharePoint column formatter a no-code solution, as easy to use as Excel. But this first step enables power users or at least “super power users” to take advantage of this powerful new capability early. We should all maximize this new feature.

Custom forms with PowerApps

As Microsoft announced earlier this year, power users can use PowerApps to build customized SharePoint forms, which previously required InfoPath or custom code.  Customized forms launch in the SharePoint list in a dynamic, responsive panel.  For a consistent user experience, the default forms will now open in the same panel.

source: Microsoft.

You can reach us at IPI SOLUTIONS for more information.


, , , , , , ,