Testing out SharePoint Syntex Content Assembly aka Modern Mail Merge

Yesterday was exciting day for SharePoint Syntex as Content Assembly (aka Modern Mail Merge) finally came to my tenant and I was able to test it out. Content Assembly allows licenced Syntex users to from a document library to convert existing documents into templates and then generate new documents from a SharePoint list or by entering the data manually.

Continue ReadingTesting out SharePoint Syntex Content Assembly aka Modern Mail Merge

Use Sites.Selected Permission with FullControl rather than Write or Read

Over the past year Microsoft have released Sites.Selected permissions for both Microsoft Graph & SharePoint which can be given to an Azure AD App (App Registration). When created the app by default with Sites.Selected permissions does not have access to any SharePoint sites and has to be explicitly added added using Microsoft Graph or PnP PowerShell (Grant-PnPAzureADAppSitePermission) to the site(s) to be administered. Both processes only give the access Read or Write permissions to the site and not Full Control.

Continue ReadingUse Sites.Selected Permission with FullControl rather than Write or Read

Adding the New Board view to a Microsoft/SharePoint List using PnP PowerShell/Power Automate (SPO Rest API)

Today some people who are running targeted release on their M365 Tenant have been able to add the Board view to new and existing Microsoft/SharePoint Lists. I wanted to automate this creation of the Board View and following on from a previous blog post I did where I created a Modern Calendar on a list. I realised to add board view it followed the same pattern – using SharePoint Rest API. Through using the Edge Developer tools I figured out the JSON & Rest call required and that the view type was ViewType2: “KANBAN”

Continue ReadingAdding the New Board view to a Microsoft/SharePoint List using PnP PowerShell/Power Automate (SPO Rest API)

PnP PowerShell/CSOM Now Works With SharePoint Sites.Selected Permission using Azure AD App

Today quietly Microsoft released a SharePoint Azure AD app registration permission level Sites.Selected. This allows PnP PowerShell cmdlets and CSOM to be used using SharePoint application permissions to a specific site(s). This is independent & different to the Microsoft Graph permission level Sites.Selected.

Continue ReadingPnP PowerShell/CSOM Now Works With SharePoint Sites.Selected Permission using Azure AD App

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