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

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

Testing out the new Power Automate/Flow commands in PnP.PowerShell + Bonus Script: Export all Flows using PnP.PowerShell

There have been several new Power Automate/Flow commands added to PnP.PowerShell (v1 released this week). In this blog article I will test these new commands out and show you how…

Continue ReadingTesting out the new Power Automate/Flow commands in PnP.PowerShell + Bonus Script: Export all Flows using PnP.PowerShell

Live London Underground Line Status – SharePoint View Formatting & Power Automate

Display on the homepage of your SharePoint intranet a live feed of London Underground line statuses using the publicly available Transport for London (TFL) API. The results are retrieved by…

Continue ReadingLive London Underground Line Status – SharePoint View Formatting & Power Automate

Office 365 Management Activity API with Power Automate – Part Three

Get audit logs, filter by workload and then write the logs to a SharePoint list Overview This post is a continuation of the blog article Office 365 Management Activity API…

Continue ReadingOffice 365 Management Activity API with Power Automate – Part Three