Extract All Table Data (Rows) In A Form Using SharePoint Syntex

One of the most exciting new features I have used recently is the ability to train SharePoint Syntex forms processing to extract rows of data from a table where the row count is variable. Before you could not extract table data from a form where the number of rows was variable and the table size varied. Read on for a guide on how to implement this in your organisation.

Continue ReadingExtract All Table Data (Rows) In A Form Using SharePoint Syntex

Adding the New Modern Calendar View to a SharePoint List using PnP PowerShell

Recently we have finally been able to add a modern calendar view to a list in SharePoint Online through the UI. Before this a calendar view was only available in SharePoint classic mode. I wanted to automate this view creation and in order to do this I turned to my trusty friend PnP PowerShell. I figured it needed to be done using SharePoint REST API by creating a new SharePoint list view using ViewType2: "MODERNCALENDAR".

Continue ReadingAdding the New Modern Calendar View to a SharePoint List using PnP PowerShell

Create Viva Connections App Using PnP PowerShell (Publish-PnPCompanyApp)

Yesterday Viva Connections (31/Mar/2021) was launched to the world and this allows you to create and then install the Viva Connections app in Teams so your SharePoint home site can be available in Teams. The Viva Connections app needs to be generated exclusively for your environment i.e. generate the app to point to your SharePoint home site url and this is done through PowerShell. I will show you how you can build a Viva Connections app using just one PnP cmdlet Publish-PnPCompanyApp

Continue ReadingCreate Viva Connections App Using PnP PowerShell (Publish-PnPCompanyApp)

Testing out the new Microsoft Graph SharePoint (specific site collection) app permissions with PnP PowerShell

Testing out the new Microsoft Graph permission level Sites.Selected which allow an app access to just specific SharePoint site collections rather than all.

Continue ReadingTesting out the new Microsoft Graph SharePoint (specific site collection) app permissions with PnP PowerShell

Download Microsoft 365 usage reports using Microsoft Graph in Power Automate

Download Microsoft 365 usage reports using Microsoft Graph in Power Automate & then write to a SharePoint document library. Customise this solution to add further workloads i.e. Teams, Yammer, SharePoint, Outlook, M365 Groups...

Continue ReadingDownload Microsoft 365 usage reports using Microsoft Graph in Power Automate

Live London Underground Line Status Solution Summary & Learnings From Converting To Azure Logic Apps

This is a follow up blog to my London Underground Line Status solution (blog post) that I developed in late 2020. I created a live London Underground Line Status board…

Continue ReadingLive London Underground Line Status Solution Summary & Learnings From Converting To Azure Logic Apps