Aggregating SharePoint List Content into a single, powerful view is something that Lightning Tools has been perfecting over the past thirteen years. We pioneered the first cross site collection rollup web part, which has constantly been improved upon. Within Office 365, content is stored in more than just SharePoint Lists. We have documents stored in OneDrive, Tasks stored in Microsoft Planner, Messages in Outlook, items in a Team Drive, and Members of a Team. All of which can be queried through Microsoft Graph. You can use the Microsoft Graph Explorer to try some of these queries out.
We’ve been busy at Lightning Tools ensuring that you can query such content in a very simple way, and still be able to design views of that content that highlight key data using column and view formatting. At the time of writing, The Lightning Conductor which includes Microsoft Graph is still in testing, but we wanted to give you the heads up on what is coming by the end of Q1.
Using the Lightning Conductor, you can choose to aggregate content using a simple or advanced configuration. The Advanced Configuration requires that you know some developer lingo, whereas the simple mode is very friendly and involves just fours steps to get your content.
Below is a typical view of the Lightning Conductor aggregating SharePoint Task List Items, and applying conditional formatting to display an icon representing high priority tasks, and data bars to show the Percent Complete.
Image shows a simple task rollup.
To configure that rollup and the view took just the four steps shown below:
Using the Lightning Conductor Quick Configuration to aggregate Tasks from SharePoint lists.
Using Microsoft Graph with the Lightning Conductor
The new rollup provider (Microsoft Graph) is also simple to configure. Initially, you select that you want to use Microsoft Graph instead of the Search or Object Model Rollup Provider.
Selecting the Microsoft Graph rollup provider
Then, we select the Entity type that we want to query data from.
Select the Entity to be used to obtain data from Microsoft Graph
Next, define your query. We’ve built some common queries for you that won’t require you to add any queries yourself. But you can also build your own custom query if you desire.
Selecting the Microsoft Graph Query
Once you have defined your query, we can concentrate on building a powerful view of the Microsoft Graph content. So, we can choose some columns from the Planner Entity.
Selecting the columns that you wish to see from Microsoft Graph Planner Entity
The final part of the configuration is to set the data formatting, and the styling of your view. This can include Grouping, Sorting, Data Format, Filters, Sorting, and Column Formatting.
Once that is configured, you can enjoy the central view of your Planner Tasks from within SharePoint!