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

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)

Office 365 Management API (M365 Audit Logs) with Logic Apps & Power Automate – including Pagination

In this blog I will show you how to retrieve M365 audit logs with Azure Logic Apps & Power Automate including the logic to handle Pagination for very large tenants (number of results returned limited to prevent response timeouts). I provide instructions and templates for both Azure Logic Apps and Power Automate so you can install in your tenant today.

Continue ReadingOffice 365 Management API (M365 Audit Logs) with Logic Apps & Power Automate – including Pagination