Category Archives: Power Platform

Flow/Power Automate and Function Apps – Securing a Function App with a Service Principal

By | November 3, 2020

I’ve written a fair bit about how I use Function apps and Flow to get data about 365 environments. There are clear advantages and disadvantages of each. Flow is incredibly slow, difficult to process data in and is in general restricted to what you can take out of Microsoft Graph. Function Apps allow you to… Read More »

Loading

Microsoft/Office 365 PowerShell in Azure Functions – AzureAD Module and Graph

By | May 10, 2021

I’m a big fan of running powershell in function apps. Sorry, no that’s wrong – I’m a big fan of NOT running powershell on “reporting servers”, “management boxes”, “that vm that does the 365 stuff” or anywhere where there is even the slightest chance I’m going to find myself fixing a problem on a windows… Read More »

Loading

Setting up an AAD App Registration/Service Principal for Power Platform/Function Apps

By | February 17, 2021

Its just one of those things. Everything is great in your tenant all best practise, no creaky old servers anywhere then the phone rings and someone from the BI team says they need an hourly output of some stuff in csv and the columns have to be in a particular order. Or someone NEEDS a… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 4 – Summary and History

By | September 2, 2020

As per Part 1 – The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanism for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business unit… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 3 – Data Cleansing

By | August 18, 2020

As per Part 1 – The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanisms for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business unit… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 2 – License Assignments

By | August 19, 2020

As per Part 1 – The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanisms for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business… Read More »

Loading

Using Power Platform and Graph for Office 365 Reporting – Part 1 – Users

By | August 13, 2020

The need here was to create a completely airgapped – i.e. no admin accounts for logging into reporting dashboards – reporting mechanisms for managers across a tenant shared between 20 or more business units. The reporting was primarily to monitor licenses and how they were assigned, what usage the business unit was getting from that… Read More »

Loading