New **PREVIEW** Power Automate Action: Generate Document Using SharePoint Syntex

I've just spotted something very exciting in my M365 tenant a new PREVIEW action in Power Automate & Azure Logic Apps for Syntex content assembly. This enables users to generate personalised documents in a workflow using SharePoint Syntex Content Assembly and this opens up the doors to the whole bulk document generation story from a workflow! This is very exciting news and one that I'm sure will be very popular! The only way previously to create documents using Syntex content assembly was from a document library and only one document could be created at a time - so there was lots of mouse and keyboard clicking!

Continue ReadingNew **PREVIEW** Power Automate Action: Generate Document Using SharePoint Syntex

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)

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

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

Create a London Underground Line Status Bot using Power Virtual Agents & Azure Management API in Dataverse for Teams

There has been an exciting development/game changer with the new Dataverse for Teams now allowing users to leverage the Azure API Management service as a custom connector in the Power Platform. This means with the custom connector you can call the Azure Management API which can then run an Azure Function which can run code i.e. PowerShell. The automation possibilities are endless and all using standard Teams licensing whereas before you would need premium licences to run some PowerShell in Azure to make a Microsoft Graph call or execute a PnP PowerShell script for example.

Continue ReadingCreate a London Underground Line Status Bot using Power Virtual Agents & Azure Management API in Dataverse for Teams

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